1. Database Reference
  2. Static Data Dictionary Views
  3. Static Data Dictionary Views: DBA_2PC_NEIGHBORS to DBA_HIST_JAVA_POOL_ADVICE
  4. DBA_AUTOTASK_JOB_HISTORY

4.130 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