W16 Script edit

Screenshot PL/SQL scheduler window W16 Script edit

This window is used for creating and editing scheduler scripts. Only scheduler users with the developer privilege can create and modify scripts.

Back to top

The script edit window contains six panels.

Back to top

Script

Screenshot PL/SQL scheduler window W16 Script edit (script panel)

Description The script description.
Public If set all scheduler users are able to create, edit or delete scheduler tasks for this scheduler script.
Public read If set all scheduler tasks created with this scheduler script can be viewed by all scheduler users.
Disabled If set the scheduler script is disabled.
Blocked If set the scheduler script is blocked.
Back to top

PL/SQL

Screenshot PL/SQL scheduler window W16 Script edit (PL/SQL panel)

The PL/SQL panel contains the plsql definitions needed for executing the script.

Script procedure The name of the procedure to be called when the scheduler script is executed.
Check procedure Contains the procedure to be executed for validation before a task is scheduled (or changed).
Check runtime If set the check procedure is again executed just before the scheduler task is activated.
Create procedure If set a PL/SQL procedure is created in the database with the same name and parameters as the scheduler script.
Back to top

Queue

Screenshot PL/SQL scheduler window W16 Script edit (queue panel)

A default scheduler queue can be defined for the script. If no default scheduler queue is defined the queue must be specified when a scheduler task is created.

Queue updatable If set another scheduler queue can be assigned to the scheduler task.
Back to top

Schedule

Screenshot PL/SQL scheduler window W16 Script edit (schedule panel)

The schedule panel contains the default scheduler task properties.

Run exclusive If set the scheduler script runs exclusive in the scheduler queue.
Run exclusive updatable If set a scheduler task can overrule the script's run exclusive setting.
Hold exclusive If set and a scheduler task must run exclusive but cannot be activated (because scheduler tasks are still running) other new scheduler tasks ready to be activated must wait.
Hold exclusive updatable If set a scheduler task can overrule the scheduler script hold exclusive setting.
Priority The priority of a scheduler script. This priority is used as default when a new scheduler task is created.
The minimum is zero and the maximum is 99.
Priority updatable If set a priority different than the priority of the scheduler script can be assigned to a scheduler task.
Keep days Specifies the number of days after which a ready scheduler task is deleted.
Keep days updatable If set a scheduler task can overrule the number of days after which it is deleted.
Load The load of the scheduler script.
Load updatable If set a load different than the load of the scheduler script can be assigned to a scheduler task.
Back to top

Child task

Screenshot PL/SQL scheduler window W16 Script edit (child task panel)

On this panel the behaviour of a new scheduler task is defined when it is created within another running task.

Never If set and the scheduler script is submitted from within another running scheduler task the running task will not be the parent for the new task.
Always If set the scheduler script can only be started from within another running scheduler task.
Queue If set a scheduler task with a parent task must be added to the number of running tasks in the scheduler queue.
Back to top

Parameters

On a parameter panel the scheduler script parameters can be defined.
Each parameter panel includes up to four buttons.

On each panel the name and the datatype (date, varchar2, number or boolean) are displayed.

Back to top
Date parameter
Screenshot PL/SQL scheduler window W16 Script edit (date parameter panel)

Description A short description of the script parameter.
Default A PL/SQL expression that returns a default value for the script parameter when a scheduler task is created and no value is given for this script parameter.
Check procedure Contains a validation procedure to be executed before a scheduler task is created.
Check runtime If set the parameter check procedure is again executed just before the scheduler task is activated.
Mandatory If set a value must be specified for the script parameter when a scheduler task is created.
Nullable If set the value NULL can be assigned as a parameter value.
Visible If set a value can be assigned to this parameter.
Time part If set the date parameter value can contain a time part.
Database view The name of the database view which contains a list of allowable values for the script parameter.
Value column An expression based on the database view containing the allowed value for the parameter.
Display column An expression used on the scheduler client for displaying the allowed value. If no expression is given the allowed value column is displayed.
List editable If set the values for the scheduler script parameters are not restricted by the list of values returned by the database view and the list of values.
Back to top
Varchar2 parameter
Screenshot PL/SQL scheduler window W16 Script edit (varchar2 parameter panel)

Description A short description of the script parameter.
Default A PL/SQL expression that returns a default value for the script parameter when a scheduler task is created and no value is given for this script parameter.
Check procedure Contains a validation procedure to be executed before a scheduler task is created.
Check runtime If set the parameter check procedure is again executed just before the scheduler task is activated.
Mandatory If set a value must be specified for the script parameter when a scheduler task is created.
Nullable If set the value NULL can be assigned as a parameter value.
Visible If set a value can be assigned to this parameter.
Hidden If set the parameter value is not visible; this can be usefull if the parameter contains sensitive information like passwords.
Trim left If set all the spaces at the beginning of the parameter value are removed.
Trim right If set all the spaces at the end of the parameter value are removed.
Case Indicates if the parameter value is converted to uppercase (U) or lowercase (L).
Default no casing is applied.
Length Specifies the maximum length of the parameter value.
Database view The name of the database view which contains a list of allowable values for the script parameter.
Value column An expression based on the database view containing the allowed value for the parameter.
Display column An expression used on the scheduler client for displaying the allowed value. If no expression is given the allowed value column is displayed.
List editable If set the values for the scheduler script parameters are not restricted by the list of values returned by the database view and the list of values.
Back to top
Number parameter
Screenshot PL/SQL scheduler window W16 Script edit (number parameter panel)

Description A short description of the script parameter.
Default A PL/SQL expression that returns a default value for the script parameter when a scheduler task is created and no value is given for this script parameter.
Check procedure Contains a validation procedure to be executed before a scheduler task is created.
Check runtime If set the parameter check procedure is again executed just before the scheduler task is activated.
Mandatory If set a value must be specified for the script parameter when a scheduler task is created.
Nullable If set the value NULL can be assigned as a parameter value.
Visible If set a value can be assigned to this parameter.
Hidden If set the parameter value is not visible; this can be usefull if the parameter contains sensitive information like passwords.
Digits Specifies the maximum number of digits including the decimals.
Decimals The maximum number of decimals.
Database view The name of the database view which contains a list of allowable values for the script parameter.
Value column An expression based on the database view containing the allowed value for the parameter.
Display column An expression used on the scheduler client for displaying the allowed value. If no expression is given the allowed value column is displayed.
List editable If set the values for the scheduler script parameters are not restricted by the list of values returned by the database view and the list of values.
Back to top
Boolean parameter
Screenshot PL/SQL scheduler window W16 Script edit (boolean parameter panel)

The boolean parameter panel does not have a list of values because the only possible values are true, false and null.

The default must return a varchar2 and not a boolean.

A default (string) value false evaluates to the boolean false, a default string value null or the empty string evaluates to null, any other default value results in the boolean value true.

The initial default boolean display values for a new parameter can be set on the preferences window (script creation panel).
Description A short description of the script parameter.
Default A PL/SQL expression that returns a default value for the script parameter when a scheduler task is created and no value is given for this script parameter.
Check procedure Contains a validation procedure to be executed before a scheduler task is created.
Check runtime If set the parameter check procedure is again executed just before the scheduler task is activated.
Mandatory If set a value must be specified for the script parameter when a scheduler task is created.
Nullable If set the value NULL can be assigned as a parameter value.
Visible If set a value can be assigned to this parameter.
Display value true A display value for the boolean value TRUE.
Display value false A display for the boolean value FALSE.
Display value null A display value for the boolean value NULL.
Back to top

Menu

Back to top

Buttons

The four buttons Date, Char, Number and Bool are used for creating a new parameter.

Back to top