Documentation view

Scheduler views are a nice way of monitoring scheduler tasks on the view window.
Views can be created by all scheduler users; no extra privileges are needed.

A lot of free predefined views can be downloaded on the download views page.
Back to top 

Create view

There is no limit on the number of views a scheduler user can create.
Select from the scheduler window menu View -> New.
Enter a name for the new view.

Screenshot PL/SQL scheduler window W38 Input

After pressing the create button the view can be edited on the view edit window.

If the view already exists the existing view is loaded and further edited.
Back to top 

Edit view

Select from the scheduler window menu View -> Edit.
Select on the view edit (select) window one or more views and press the edit button. For each selected view the view edit window is opened on which the view can be changed.

The view edit window (columns panel) consist of the following columns.

Screenshot PL/SQL scheduler window W31 View edit

In the above screenshots a view is defined on which the scheduler script owner, scheduler script name, scheduler task id and the date and time the task is scheduled is displayed (the last is not visible on the screenshot).
Only scheduler scripts with the name SO_DEMO_SLEEP will be selected.
Also the descriptions have been changed.

For a full list of all the available columns and what they mean check the documentation on the database view SO_VW_TASKS.
All views get their data from this database view.

When the view is ready press the open button; the view is saved and the view window is opened. When the preview button is used the view is not saved and the preview window is opened; this is the same as the view window except an extra save menu option is added.

Screenshot PL/SQL scheduler window W03 View Back to top 

Open views

Select from the scheduler window menu View -> Open.
Only views owned by the scheduler user can be opened and are selectable on the view open (select) window.

Screenshot PL/SQL scheduler window W32 View open (select)

A view can also be opened on the view edit window.

Back to top 

Copy views

Select from the scheduler window menu View -> Copy.
The views from all scheduler users can be copied and are displayed on the view copy (select) window.

Screenshot PL/SQL scheduler window W35 View copy (select)

For each selected view a (new) name must be entered.

Screenshot PL/SQL scheduler window W38 Input

After a new name is given the view edit window is opened on which the copied view can be changed and saved.

Back to top 

Delete views

Select from the scheduler window menu View -> Delete.
Only views owned by the scheduler user are shown on the view delete (select) window.

Screenshot PL/SQL scheduler window W34 View delete (select) Back to top