DBA_AUTOTASK_JOB_HISTORY

DBA_AUTOTASK_JOB_HISTORY displays the history of automated maintenance task job runs. Jobs are added to this view after they finish executing.

Column Datatype NULL Description

CLIENT_NAME

VARCHAR2(64)

  

Name of the automated maintenance client

WINDOW_NAME

VARCHAR2(261)

  

Name of the maintenance window

WINDOW_START_TIME

TIMESTAMP(6) WITH TIME ZONE

  

Start time of the maintenance window

WINDOW_DURATION

INTERVAL DAY(9) TO SECOND(6)

  

Duration of the maintenance window

JOB_NAME

VARCHAR2(261)

  

Name of the maintenance job

JOB_STATUS

VARCHAR2(30)

  

Status of the maintenance job

JOB_START_TIME

TIMESTAMP(6) WITH TIME ZONE

  

Start time of the maintenance job

JOB_DURATION

INTERVAL DAY(3) TO SECOND(0)

  

Duration of the maintenance job

JOB_ERROR

NUMBER

  

Error code for the job (if any)

JOB_INFO

VARCHAR2(4000)

  

Additional information about the job