5.148 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