W25 Task properties

Screenshot PL/SQL scheduler window W25 Task properties

On this window all the properties of one scheduler task can be found.
The window contains the next panels.

Back to top 

Script

Screenshot PL/SQL scheduler window W25 Task properties (script panel)

This panel contains information about the scheduler script.

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

Schedule

Screenshot PL/SQL scheduler window W25 Task properties (schedule panel)

This panel contains information about when the task must be activated.

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.
Priority The priority of the scheduler task.
Load The load of the task.
Run exclusive If set the scheduler task runs exclusive in 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.
Historical If set the scheduler task can be scheduled before the date it is created.
Hold exclusive If set other scheduler tasks must wait when this scheduler task needs exclusive access to the scheduler queue.
Restart on error If set the scheduler task is restarted immediate if the task is ready with status Error.
Back to top 

Task

Screenshot PL/SQL scheduler window W25 Task properties (task panel)

This panel contains information about when the task was created, activated, ready, etc...

Id The scheduler task identifier.
Status The scheduler task status as text.
Parent The parent scheduler task id.
Restart If the scheduler task is a restart then this is the id of the original task.
Comment Contains comment about the scheduler task.
Info Runtime scheduler task info.
Created The date and time the scheduler task was created.
Created by The scheduler user who created the scheduler task.
Scheduled The date and time the scheduler task is scheduled and must be activated.
Blocked by The task id where the task is waiting on before it can be activated.
Activated The date and time the scheduler task is activated by the scheduler server.
Not activated Contains the status why a task is not activated.
Running The date and time the scheduler task started running.
Waiting on The task id where the task is waiting on before it can continue running
Ready The date and time the scheduler task was ready.
Elapsed The time the scheduler task is running.
Delete The date and time the scheduler task will be deleted.
Back to top 

Queue

Screenshot PL/SQL scheduler window W25 Task properties (queue panel)

This panel contains the scheduler queue information.
If the queue is closed the extra text (CLOSED) is added after the description.

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

Flow

Screenshot PL/SQL scheduler window W25 Task properties (flow panel)

This panel contains information about the tasks flow.

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.
Unknown The flow action if the flow task has status Unknown.
Pass The flow action if the flow task has status Passed.
Interval. The period after the very first flow task when this scheduler task must be activated.
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 

Progress

Screenshot PL/SQL scheduler window W25 Task properties (progress panel)

This panel contains runtime scheduler task progress information.

Total The total items of the running scheduler task that needs to be processed.
Done The total items of the running task that are processed.
Elapsed The time elapsed (displayed as "HH24:MI:SS").
Remaining The estimated time (displayed as "HH24:MI:SS") needed for processing the remaining items.
Ready The estimated date and time at which all the items will be processed.
Percentage done The percentage done.
Back to top 

Suspend

Screenshot PL/SQL scheduler window W25 Task properties (suspend panel)

This panel contains the scheduler task suspend information.

Status The scheduler task suspend status.
By The scheduler user who suspended the scheduler task for the last time.
Last check The last date and time the running scheduler task checked if it had to be suspended.
Request The date and time the last suspend request was done.
Checks The total number of times the running scheduler task checked if it had to be suspended.
At The date and time at which the scheduler task was suspended.
Time The total time the scheduler task has been suspended.
Till The date and time untill the scheduler task is suspended.
Back to top 

Output

Screenshot PL/SQL scheduler window W25 Task properties (output panel)

This panel contains a list of every task output destination.
A scheduler task always has minimal one output destination which is automatically created when the task is activated.

Destination The name of the task output destination.
Lines The number of task output lines written to the task output destination.
Bytes The total size of the task output.
Created The date and time the task output destination was created.
Task The date and time the last task output for this task output destination was generated by the running scheduler task and send to the scheduler server.
Server The date and time the last task output for this destination was written to the database by the scheduler server.

The panel inncludes four buttons.

Back to top 

Parameters

Screenshot PL/SQL scheduler window W25 Task properties (parameters panel)

This panel contains the task parameters.

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

Days of the week

Screenshot PL/SQL scheduler window W25 Task properties (days of the week panel)

This panel contains checkboxes for each day of the week. If a day is unchecked the task will not run on that particular day.

mon tue wed thu fri sat sun If set the task is allowed to run on the specified day. If a task is created on monday and the monday is not set the task will be scheduled on tuesday.
Back to top 

Months

Screenshot PL/SQL scheduler window W25 Task properties (months panel)

This panel contains checkboxes for each month of the year. If a month is unchecked the task is not scheduled in that month.

jan feb mar apr may jun jul aug sep oct nov dec If set the scheduler task is allowed to run in that month.
Back to top 

Days of the month

Screenshot PL/SQL scheduler window W25 Task properties (days of the month panel)

This panel contains checkboxes for every day in any month of the year. If a day is unchecked the task is not scheduled on that specified day in any month.

1 .. 31 If set the task is allowed to run on that specified day in any of the twelve months.
Back to top 

Weeks

Screenshot PL/SQL scheduler window W25 Task properties (weeks panel)

This panel contains checkboxes for every week of the year. If a week is unchecked the task is not scheduled in that particular week.

1 .. 53 If set then the task is allowed to be scheduled on the specified week.
Back to top 

Repeat

Screenshot PL/SQL scheduler window W25 Task properties (repeat panel)

This panel contains the number of times a task must be repeated.

Number The total times a scheduler task must be repeated.
Current Each repeated scheduler task is numbered starting with one.
Till The time (format HH24:MI:SS) untill the scheduler task is repeated.
Interval The period between each 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.
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 W25 Task properties (overtime panel)

This panel contains overtime information.

Indication The overtime indication code.
At The date and time at which the overtime period expires.
Period The overtime period.
Days
Hours
Minutes
Seconds
The total of these four values determine the overtime period.
Back to top

Trace

Screenshot PL/SQL scheduler window W25 Task properties (trace panel)

This panel contains information if a trace has been 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 W25 Task properties (dbms_job panel)

This panel contains restart information if the oracle session that executes the task fails.

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.
Restarts done The total number of restarts done for this task.
Restart at The date at which the task is restarted.
Back to top

Menu

Properties

The first six menu items are only enabled if these tasks exist.

Task

The task menu options are only available if the specific action can be applied.

Back to top

Task -> Edit

A scheduler task can only be edited if is not activated.

Back to top

Task -> Edit -> Schedule

After the schedule date is changed the new date will be checked if it is a valid date. If it is not a valid date, because for example the new date is a monday and the task is not allowed to be activated on that day, a new valid date will be calculated automatically.

Back to top

Task -> Edit -> Move

When the schedule date is moved to another date it is not checked if it is a valid date. It will always be activated on the requested date.
When the task is ready and it must be rescheduled again a new schedule date is calculated according to the original schedule date.

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

Display

With this menu the layout of the properties window can be defined for the associated script. If the layout is saved the next time the window is opened for a task based on the same script the same panels are displayed.
All panels can be disabled or enabled. Each menu check item corresponds to the panel with the same name.

The default layout is specified on the preferences window.

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

Button

Back to top