Documentation queue

When a scheduler task is created a queue must be assigned. Scheduler tasks are not activated when a queue is closed.

The queue of an Activated scheduler task cannot be changed anymore.

A queue has the next properties.

Name

The scheduler queue name.
The name is always uppercase and has a maximum length of 32 characters.
After a queue is created the name cannot be changed anymore.

Description

The queue description.
The description has a maximum length of 40 characters.

Status

The scheduler queue status; Open or Closed.
If a queue is closed no scheduler tasks are Activated.

Minimum

The minimum priority of the queue.
The minimum can range from 0 till 99.
Scheduler tasks with a lower priority are not activated.

Maximum

The maximum priority of the queue.
The maximum can range from 0 till 99.
Scheduler tasks with a higher priority are not activated.

Limit

The scheduler queue limit; the maximum number of active scheduler tasks in the queue.
The queue limit can range from 0 till 9999.

When a scheduler script has property "childtask queue" set and the scheduler task has a parent task the task is added to the number of tasks in a queue.
Back to top 

Privileges needed

A scheduler user who wants to create, change or delete queues needs the administrator privilege.

Back to top 

Create queues

Select from the scheduler window menu Queue -> New.
Enter a name for the new queue.

Screenshot PL/SQL scheduler window W38 Input

After pressing the create button the queue is immediately created.

If a queue already with the same name exists no error is raised and the original queue settings are not changed.

After creation the queue edit window is opened on which the queue properties can be changed.
If a name of an already existing queue was entered the current queue settings are displayed.

Back to top 

Edit queues

Select from the scheduler window menu Queue -> Edit.
Select on the queue edit (select) window one or more queues and press the edit button.

Screenshot PL/SQL scheduler window W46 Queue edit (select)

For each selected queue the queue edit window is opened.

Screenshot PL/SQL scheduler window W09 Queue edit Back to top 

Open queues

Select from the scheduler window menu Queue -> Open.
Only closed queues are shown on the queue open window.

Screenshot PL/SQL scheduler window W47 Queue open

Queues can also be opened on the queue edit window, the queue monitor window and the queue properties window.

Back to top 

Close queues

Select from the scheduler window menu Queue -> Close.
Only open queues are shown on the queue close window.

Screenshot PL/SQL scheduler window W48 Queue close

Queues can also be closed on the queue edit window, the queue monitor window and the queue properties window.

Back to top 

Delete queues

Select from the scheduler window menu Queue -> Delete.

Only scheduler queues can be deleted for which no scheduler task exists and who are specified as the default scheduler script queue.

Only queues who can be deleted are shown on the queue delete window.

Screenshot PL/SQL scheduler window W50 Queue delete

Queues can also be deleted on the queue edit window, the queue monitor window and the queue properties window.

Back to top

Server log

Queue create, edit or deleted actions are written to the scheduler server log.
The server log can be viewed on the server monitor window. Next a screenshot on what is logged after the queue BATCH has been modified by the scheduler user PLSQLSCH.
Notice that after the queue has been changed the server process receives an interrupt and checks if scheduler tasks must be activated.

Screenshot PL/SQL scheduler window W23 Server monitor Back to top