[Home] [Help] [Dependency Information]
Object Name: | DBA_AUTOTASK_JOB_HISTORY |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Automated Maintenance Jobs history
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
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 | (13) | Start time of the Maintenance Window | |
WINDOW_DURATION | INTERVAL DAY(9) TO SECOND(6) | (24) | 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 | (13) | Start time of the Maintenance Job | |
JOB_DURATION | INTERVAL DAY(3) TO SECOND(0) | (11) | Duration of the Maintenance Job | |
JOB_ERROR | NUMBER | Error code (if any) for the job | ||
JOB_INFO | VARCHAR2 | (4000) | Additional information about the job |
Cut, paste (and edit) the following text to query this object:
SELECT CLIENT_NAME
, WINDOW_NAME
, WINDOW_START_TIME
, WINDOW_DURATION
, JOB_NAME
, JOB_STATUS
, JOB_START_TIME
, JOB_DURATION
, JOB_ERROR
, JOB_INFO
FROM SYS.DBA_AUTOTASK_JOB_HISTORY;
|
|
|