DBA_AUTOTASK_SCHEDULE_CONTROL
DBA_AUTOTASK_SCHEDULE_CONTROL displays the status of automated tasks.
| Column | Datatype | NULL | Description |
|---|---|---|---|
DBID |
NUMBER |
NOT NULL |
Identifier of the database used by the task |
TASK_ID |
NUMBER |
NOT NULL |
Identifier of the task |
INSTANCE_NUMBER |
NUMBER |
Instance number for the task | |
TASK_NAME |
VARCHAR2(64) |
Name of the task | |
STATUS |
VARCHAR2(10) |
Status of the task Possible values:
|
|
INTERVAL |
NUMBER |
The time interval between task invocations (in seconds) | |
MAX_RUN_TIME |
NUMBER |
Maximum run time allowed for the task before it is stopped (in seconds) | |
ELAPSED_TIME |
NUMBER |
Elapsed time of the last execution (in seconds) | |
LAST_SCHEDULE_TIME |
TIMESTAMP(3) WITH TIME ZONE |
Last time the task was scheduled to execute | |
LAST_EXEC_INSTNUM |
NUMBER |
Oracle RAC instance number for the database instance used for the last execution of the task | |
SUSPENDABLE_EPOCH_TIME |
NUMBER |
Time when the task will be released from suspension and resume being scheduled The time is displayed in UNIX epoch time format. |
|
ENABLED |
VARCHAR2(5) |
Indicates whether the task is enabled (TRUE) or not (FALSE) |