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:

• FAILED
• RUNNING
• SCHEDULED
• SKIPPED
• SUCCEEDED
• TERMINATED

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)