DBA_AUTOTASK_CLIENT_HISTORY

DBA_AUTOTASK_CLIENT_HISTORY displays per-window history of job execution counts for each automated maintenance task. This information is viewable in the Job History page of Enterprise Manager.


Column Datatype NULL Description

CLIENT_NAME

VARCHAR2(64)

 

Name of the client

WINDOW_NAME

VARCHAR2(261)

 

Name of the maintenance window

WINDOW_START_TIME

TIMESTAMP(6) WITH TIME ZONE

 

Maintenance window start time

WINDOW_DURATION

INTERVAL DAY(9) TO SECOND(6)

 

Window duration (NULL for currently open window)

JOBS_CREATED

NUMBER

 

Number of jobs created on behalf of the client in this window

JOBS_STARTED

NUMBER

 

Number of jobs started on behalf of the client during the maintenance window

JOBS_COMPLETED

NUMBER

 

Number of jobs successfully completed on behalf of the client during the maintenance window

WINDOW_END_TIME

TIMESTAMP(6) WITH TIME ZONE

 

Window end time