W11 Queue properties

Screenshot PL/SQL scheduler window W11 Queue properties

On this window one scheduler queue is monitored.
Use the queue monitor window if all queues needs to be monitored.

Only scheduler users with the administrator privilege can see all the scheduler tasks in the queue.
Scheduler users that don't have the administrator privilege only see the scheduler tasks based on scheduler scripts to which they have access.
Back to top

Queue

The queue panel contains the queue properties.

Name The scheduler queue name.
Description The queue description.
Status The scheduler queue status; Open or Closed.
Minimum The minimum priority of the queue.
Maximum The maximum priority of the queue.
Limit The scheduler queue limit; the maximum number of active scheduler tasks in the queue.
Back to top

Tasks

The tasks panel contains a summary of all the scheduler tasks scheduled in this queue.

Tasks The total number of scheduler tasks in the scheduler queue.
Scheduled The total number of scheduler tasks with status scheduled.
Ready The total number of scheduler tasks that have been activated and are ready.
Hold The total number of scheduler tasks with status hold.
Activated The total number of scheduler tasks with status active.
Running The total number of scheduler tasks with status running.
Waiting The total number of running scheduler tasks who are waiting on other running tasks to finish.
Suspended The total number of running scheduler tasks who are currently in suspend mode.
Ready The total number of scheduler tasks that have been activated and are ready.
Finished The total number of ready scheduler tasks with status finished.
Passed The total number of scheduler tasks with status passed.
Unknown The total number of ready scheduler tasks with status unknown.
Error The total number of ready scheduler tasks with status error.
Deleted The total number of scheduler tasks with status delete but who are not physically deleted yet from the database.
Back to top

Not activated

The not activated panel contains a summary of all the scheduler tasks that could not be activated.

Closed The total number of scheduler tasks that could not be activated because the scheduler queue is closed.
Low The total number of scheduler tasks that could not be activated because their priority is below the scheduler queue minimum priority.
High The total number of scheduler tasks that could not be activated because their priority is greater than the scheduler queue maximum priority.
Full The total number of scheduler tasks that could not be activated because the scheduler queue limit has been reached.
Exclusive The total number of scheduler tasks that could not be activated because they need exclusive access to the scheduler queue.
Blocked The total number of scheduler tasks that could not be activated because a task with exclusive access is running in the scheduler queue.
Server The total number of scheduler tasks that could not be activated because a scheduler server error has occurred.
The error can be found in the scheduler server log.
Script The total number of scheduler tasks that could not be activated because the scheduler script is disabled.
User The total number of scheduler tasks that could not be activated because the scheduler users who created the scheduler scripts are disabled.
Load The total number of scheduler tasks that could not be activated because the server maximum load has been reached.
Overtime The total number of scheduler tasks for which an overtime period is defined but could not be activated in time.
Hold The total number of scheduler tasks that could not be activated because the status is set to hold.
Flow The total number of scheduler tasks part of a flow for which a user action is required.
Wait The total number of scheduler tasks who are part of a flow and are waiting on the parent flow task to finish.
Back to top

Menu

Properties

Back to top

Queue

Only scheduler users with the administrator privilege can create, edit, open, close or delete scheduler queues.

Back to top

Timer

Back to top

Buttons

Depending on the scheduler queue status an open or close button is visible.

Back to top