W22 Script submit

Screenshot PL/SQL scheduler window W22 Script submit

This window is used for submitting scheduler scripts and thus scheduling new scheduler tasks.
The window contains different panels, each panel except the parameters panel can be enabled or disabled.

If a panel is disabled the content is no longer visible but the entered values are still used.
Back to top 

Parameters

Screenshot PL/SQL scheduler window W22 Script submit (parameters panel)

This panel contains the scheduler script parameters
If a script has no parameters the panel will be empty.

Description A short description of the script parameter.
Back to top 

Schedule

Screenshot PL/SQL scheduler window W22 Script submit (schedule panel)

On this panel the information when the new scheduler task needs to be activated is given.

Date The date used as a basis for calculating the final schedule date.
Till The last date the scheduler task can be scheduled.
Shift days The number of days that must be added to each schedule date.
Maximum tasks The maximum number of times (days) the scheduler task can be scheduled.
Moved A new schedule date only applied to this task.
The scheduler task is activated exactly on this date and time; all other schedule settings are ignored.
Keep days The number of days after which a ready scheduler task is deleted.
Load The load of the task.
Priority The priority of the scheduler task.
Run exclusive If set the scheduler task runs exclusive in the scheduler queue.
Hold exclusive If set other scheduler tasks must wait when this scheduler task needs exclusive access to the scheduler queue.
Next if error If set the scheduler task must be rescheduled even when it is ready with an error status.
If not set the scheduler task must be rescheduled manually.
This property only applies to scheduler tasks who are scheduled more than once.
Restart on error If set the scheduler task is restarted immediate if the task is ready with status Error.
Historical If set the scheduler task can be scheduled before the date it is created.
Precreate tasks If set and the scheduler task is scheduled more than once then all the tasks are created immediately.
Back to top 

Task

Screenshot PL/SQL scheduler window W22 Script submit (task panel)

Status The initial scheduler task status.
Last scheduled Contains the schedule date of the last task created with this window.
Comment Contains comment about the scheduler task.
Back to top 

Queue

Screenshot PL/SQL scheduler window W22 Script submit (queue panel)

If the scheduler queue is closed the description contains the extra text (CLOSED).

Name The scheduler queue name.
Description The queue description.
Back to top 

Flow

Screenshot PL/SQL scheduler window W22 Script submit (flow panel)

The scheduler flow properties are only used if a flow task id is given (in the wait for task field).

Wait for task The flow task identifier this task must be waiting on.
Reschedule If set this scheduler task is also rescheduled when the previous flow task is rescheduled.
Restart If set this scheduler task is also restarted when the previous flow task is restarted.
Finished The flow action if the flow task has status Finished.
Error The flow action if the flow task has status Error.
Pass The flow action if the flow task has status Passed.
Unknown The flow action if the flow task has status Unknown.
Days
Hours
Minutes
Seconds
The sum of these values incremented with the schedule date of the very first flow task is the new schedule date of this task.
Back to top 

Days of the week

Screenshot PL/SQL scheduler window W22 Script submit (days of the week panel)

On this panel for each day of the week, monday till sunday, can be specified if the scheduler task is allowed to be activated on that day.
At least one day must be enabled.

Back to top 

Months

Screenshot PL/SQL scheduler window W22 Script submit (months panel)

On this panel the months of the year can be specified on which the scheduler task is allowed to be activated.
At least one month must be enabled.

Back to top 

Days of the month

Screenshot PL/SQL scheduler window W22 Script submit (days of the month panel)

On this panel can be specified for every day in all the months of the year if a scheduler task is allowed to be activated.

Back to top 

Weeks

Screenshot PL/SQL scheduler window W22 Script submit (weeks panel)

On this panel for every week of the year can be specified if a scheduler task is allowed to be activated.

Back to top 

Repeat

Screenshot PL/SQL scheduler window W22 Script submit (repeat panel)

On this panel the number of times a scheduler task must be repeated after it has been activated.
The default (and minimum value) is once every day. If the repeat number has a value one then all the other repeat properties are ignored.

Number The total times a scheduler task must be repeated.
Till The time (format HH24:MI:SS) untill the scheduler task is repeated.
Historical If set the next repeated task can be scheduled before the current date and time, otherwise these scheduler tasks are skipped.
From starttime If set the next repeat is scheduled at the schedule date of the last task incremented with the repeat interval period.
If not set the next repeat is schedule at the date and time the last repeated task was ready incremented with the repeat interval.
Precreate tasks If set all the repeated tasks are created immediately when the scheduler script is submitted.
Hours
Minutes
Seconds
The total of these three values determine the repeat interval between each repeated scheduler task.
Back to top 

Overtime

Screenshot PL/SQL scheduler window W22 Script submit (overtime panel)

On the overtime panel the overtime period is defined.
This is the period after the schedule date in which the scheduler task must be activated.
When the period expires the overtime indication determines what action must be taken for the task.

Indication The overtime indication code.
Days
Hours
Minutes
Seconds
The total of these four values determine the overtime period.
Back to top 

Trace

Screenshot PL/SQL scheduler window W22 Script submit (trace panel)

On this panel the scheduler trace or the oracle trace can be enabled.

Task If set the scheduler trace is enabled.
Oracle If set an oracle trace file is generated containing all the sql statements used by the script program.
Back to top 

Dbms_job

Screenshot PL/SQL scheduler window W22 Script submit (job panel)

Oracle restart If set and the running scheduler task database session aborts abnormally (for example the database shuts down during execution) it is restarted.
Restart wait The period in seconds after which the scheduler task must be restarted.
Back to top 

Menu

Script

Back to top 

Display

With the display menu the layout of the window can be defined for this scheduler script. If the layout is saved the next time the window is opened for the same script the same panels are displayed.
Each of the panels except the parameters panel can be disabled or enabled. Each menu check item corresponds to the panel with the same name. Properties set or values entered on a panel are not lost when it is disabled.

The default layout is specified on the preferences window.

The on submit menu item contain four actions that can take place when the scheduler script is submitted.
More than one action can be enabled.

The next extra display menu options are available for managing the window layout.

Button

Back to top  Back to top