[Home] [Help] [Dependency Information]
Object Name: | DBA_SCHEDULER_JOB_LOG |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Logged information for all scheduler jobs
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
LOG_ID | NUMBER | Yes | The unique id that identifies a row | |
LOG_DATE | TIMESTAMP(6) WITH TIME ZONE | (13) | The date of this log entry | |
OWNER | VARCHAR2 | (128) | The owner of the scheduler job | |
JOB_NAME | VARCHAR2 | (261) | The name of the scheduler job | |
JOB_SUBNAME | VARCHAR2 | (261) | The subname of the scheduler job (for a chain step job) | |
JOB_CLASS | VARCHAR2 | (128) | The class the job belonged to at the time of entry | |
OPERATION | VARCHAR2 | (30) | The operation corresponding to this log entry | |
STATUS | VARCHAR2 | (30) | The status of the operation, if applicable | |
USER_NAME | VARCHAR2 | (128) | The name of the user who performed the operation, if applicable | |
CLIENT_ID | VARCHAR2 | (64) | The client id of the user who performed the operation, if applicable | |
GLOBAL_UID | VARCHAR2 | (32) | The global_uid of the user who performed the operation, if applicable | |
CREDENTIAL_OWNER | VARCHAR2 | (261) | Owner of the credential used for this external or remote job run | |
CREDENTIAL_NAME | VARCHAR2 | (261) | Name of the credential used for this external or remote job run | |
DESTINATION_OWNER | VARCHAR2 | (128) | Owner of destination object used in remote run or NULL if no object used | |
DESTINATION | VARCHAR2 | (128) | The destination for a remote job operation | |
ADDITIONAL_INFO | CLOB | (4000) | Additional information on this entry, if applicable |
Cut, paste (and edit) the following text to query this object:
SELECT LOG_ID
, LOG_DATE
, OWNER
, JOB_NAME
, JOB_SUBNAME
, JOB_CLASS
, OPERATION
, STATUS
, USER_NAME
, CLIENT_ID
, GLOBAL_UID
, CREDENTIAL_OWNER
, CREDENTIAL_NAME
, DESTINATION_OWNER
, DESTINATION
, ADDITIONAL_INFO
FROM SYS.DBA_SCHEDULER_JOB_LOG;
|
|
|