W25 Task properties

On this window all the properties of one
scheduler task can be found.
The window contains the next panels.
- Script
- Schedule
- Task
- Queue
- Flow
- Progress
- Suspend
- Output
- Parameters
- Days of the week
- Months
- Days of the month
- Weeks
- Repeat
- Overtime
- Trace
- Dbms_job
Script

This panel contains information about the scheduler script.
Name | The scheduler script name. |
Description | The script description. |
Schedule

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. |
Task

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. |
Queue

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. |
Flow

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. |
Progress

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. |
Suspend

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. |
Output

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.
![]() |
Output | Open the task output window for the default task output destination. |
![]() |
Open | Open the task output window for the selected destinations. |
![]() |
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. |
![]() |
All | Open the task output window for all destinations. |
Parameters

This panel contains the task parameters.
Description | A short description of the script parameter. |
Value | The parameter value. |
Days of the week

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. |
Months

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. |
Days of the month

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. |
Weeks

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. |
Repeat

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. |
Overtime

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. |
Trace

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. |
Dbms_job

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. |
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. | |
![]() |
Refresh | Refresh the content of the window. |
![]() |
Exit | Close the window. |
Task
The task menu options are only available if the specific action can be applied.
![]() |
Hold |
Sets the scheduler task status to
hold.
Can only be applied to scheduler tasks with status scheduled. |
![]() |
Release |
Sets the scheduler task status back to
scheduled.
Can only be applied to scheduler tasks with status hold. |
![]() |
Restart |
Restart the
scheduler task.
Can only be applied to scheduler tasks who are ready and have not been restarted before. |
![]() |
Kill | Kill the scheduler task, only tasks with status running or waiting can be killed. |
![]() |
Delete | Delete the scheduler task. |
![]() |
Suspend |
the scheduler task.
Can only be applied to scheduler tasks for which the suspend option is enabled. |
![]() |
Unsuspend | Unsuspend the scheduler task if it has been suspended. |
![]() |
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. |
![]() |
Tree | Open a task tree window. |
![]() |
Output |
Open the task output window
for the default task output.
For the other task output destinations use the task properties window. |
![]() |
Edit | Open the task edit submenu. |
![]() |
Copy | Create a new scheduler task with the same properties on the task copy window. |
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. |
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. |
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. |
Queue
Only scheduler users with the administrator privilege can create, edit, open, close or delete scheduler queues.
![]() |
Properties | Open the queue properties window. |
![]() |
New | Create a new scheduler queue. |
![]() |
Edit | Open the queue edit window. |
![]() |
Delete | Delete the scheduler queue. |
![]() |
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. |
![]() |
Open | Open the scheduler queue. |
![]() |
Close | Close the scheduler queue. |
Timer
![]() |
Start | Starts the timer for automatically refreshing the content of the window. |
![]() |
Stop | Stop the timer for refreshing the content of the window. |
![]() |
Interval | Specify a new interval in seconds for the refresh timer. The minimum interval is ten seconds. |
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 next extra display menu options are available for managing the window layout.
![]() |
Delete | Deletes the current saved layout and returns to the default layout. |
![]() |
Save | Saves the current window layout. Next time the same window is opened the last saved layout will be used. |
![]() |
Restore | Restores the current layout to the last saved layout. |
Button
![]() |
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. |
|
![]() |
Tree | Open a task tree window. |
![]() |
Output |
Open the task output window
for the default task output.
For the other task output destinations use the task properties window. |
![]() |
Exit | Close the window. |