Screenshots

Scheduler scripts

Screenshot PL/SQL scheduler scripts

Scheduler scripts contain the definition of the PL/SQL programs that needs to be scheduled.

On this screenshot a script is created for the PL/SQL procedure SO_DEMO.SLEEP with one parameter.

Screenshot contains a snapshot of the script edit (select) window and the script edit window.

Back to top 

Schedule programs

Screenshot PL/SQL scheduler schedule

If a script is scheduled a scheduler task is created. A task specifies on which date, time, day, etc... the script must be executed.

On this screenshot a script is scheduled on monday till friday at 23:00 till 1-1-2009 but not in june and july.

Screenshot contains a snapshot of the script submit (select) window and the script submit window.

Back to top 

Queue monitor

Screenshot PL/SQL scheduler queues

All tasks are scheduled in a scheduler queue. All queues can be monitored on how many tasks are scheduled, running, ready, waiting, etc....

Screenshot contains a snapshot of the queue monitor window and the queue properties window.

Back to top 

Task properties

Screenshot PL/SQL scheduler tasks

When a scheduler task is executed it's progress can easily be viewed.

If a task is not executed yet it's schedule properties can easiliy be changed.

Screenshot contains a snapshot of the view window and the task properties window.

Back to top 

Display views

Screenshot PL/SQL scheduler views

All tasks can be monitored with user defined scheduler views.

On this screenshot one of the predefined views available online is shown.

Screenshot contains a snapshot of the view edit window and the view window.

Back to top 

Users

Screenshot PL/SQL scheduler users

All scheduler users can be easily monitored and assigned or revoked specific privileges.

On this screenshot the privileges and scripts of user PLSQL5 are shown.

Screenshot contains a snapshot of the user monitor window and the user privileges window.

Back to top