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.

icon Output Open the task output window for the default task output destination.
icon Open Open the task output window for the selected destinations.
icon Export Save the output for the selected destinations to a file on a local or network disk. The output export window is opened for each selected output destination on which the directory can be selected and the filename can be entered.
icon All Open the task output window for all destinations.
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.

Root Opens the task properties window for the root task if this task is part of a tree.
The root task is the most upper task in the task tree hierarchy.
Parent Opens a task properties window for the parent task if this task has one.
Child(s) Opens a task properties window for all the child tasks.
Restart Opens the task properties window for the task for which this task is a restart.
Blocked Opens the task properties window for the task that blocks this task.
Waiting Opens the task properties window for the task this running task is waiting on.
icon Refresh Refresh the content of the window.
icon Exit Close the window.

Task

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

icon Hold Sets the scheduler task status to hold.
Can only be applied to scheduler tasks with status scheduled.
icon Release Sets the scheduler task status back to scheduled.
Can only be applied to scheduler tasks with status hold.
icon Restart Restart the scheduler task.
Can only be applied to scheduler tasks who are ready and have not been restarted before.
icon Kill Kill the scheduler task, only tasks with status running or waiting can be killed.
icon Delete Delete the scheduler task.
icon Suspend the scheduler task.
Can only be applied to scheduler tasks for which the suspend option is enabled.
icon Unsuspend Unsuspend the scheduler task if it has been suspended.
icon Activate Activate the scheduler task now.
Can only be applied to scheduler tasks that have not been activated yet.
This is a shortcut for specifying a "schedule move date" with the current date and time and setting the status to "scheduled" if the current status is hold.
icon Tree Open a task tree window.
icon Output Open the task output window for the default task output.
For the other task output destinations use the task properties window.
icon Edit Open the task edit submenu.
icon Copy Create a new scheduler task with the same properties on the task copy window.
Back to top

Task -> Edit

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

Parameters Open the task parameters window and change the parameter values.
Priority Change the scheduler task priority.
Queue Open the task edit (select queue) window and select a new scheduler queue for scheduler task.
Edit Open the task edit window.
Schedule Open the schedule submenu.
Move Open the move submenu.
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.

Date Change the date and time on which the scheduler task is scheduled.
Seconds +/- Incrementes or decrements the date and time on which the scheduler task is scheduled with seconds.
Minutes +/- Incrementes or decrements the date and time on which the scheduler task is scheduled with minutes.
Hours +/- Incrementes or decrements the date and time on which the scheduler task is scheduled with hours.
Days +/- Incrementes or decrements the date and time on which the scheduler task is scheduled with days.
Date +/- Changes only the date on which the scheduler task is scheduled.
Skip Skip the current scheduled scheduler task and calculate a new schedule date.
Skip till Skip the current scheduled scheduler task and calculate a new schedule date on or after the given date and time.
Skip tasks Skip the current scheduled scheduler task and calculate a new schedule date the requested number of times.
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.

Date Specify a date and time on which scheduler task must be activated.
Seconds +/- Incrementes or decrements the moved scheduled date with seconds.
Minutes +/- Incrementes or decrements the moved scheduled date with minutes.
Hours +/- Incrementes or decrements the moved scheduled date with hours.
Days +/- Incrementes or decrements the moved scheduled date with days.
Clear Clear the scheduled move date.
Back to top

Queue

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

icon Properties Open the queue properties window.
icon New Create a new scheduler queue.
icon Edit Open the queue edit window.
icon Delete Delete the scheduler queue.
icon Export Create a plsql creation script for the scheduler queue.
A queue export window is opened on which the directory and the name of the file can be specified.
icon Open Open the scheduler queue.
icon Close Close the scheduler queue.
Back to top

Timer

icon Start Starts the timer for automatically refreshing the content of the window.
icon Stop Stop the timer for refreshing the content of the window.
icon Interval Specify a new interval in seconds for the refresh timer. The minimum interval is ten seconds.
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.

icon Delete Deletes the current saved layout and returns to the default layout.
icon Save Saves the current window layout. Next time the same window is opened the last saved layout will be used.
icon Restore Restores the current layout to the last saved layout.

Button

icon Refresh Refresh the content of the window.
Timer on/off Turns the automatic refresh timer on or off.
The remaning seconds before the window is refreshed are displayed on the button.
icon Tree Open a task tree window.
icon Output Open the task output window for the default task output.
For the other task output destinations use the task properties window.
icon Exit Close the window.
Back to top