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