5.194 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

NOT NULL

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

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

Note:

This view is available starting with Oracle Database 21c.