Oracle® Database Reference 10g Release 1 (10.1) Part Number B10755-01 |
|
|
View PDF |
ALL_SCHEDULER_JOB_LOG
displays log information for the Scheduler jobs accessible to the current user.
DBA_SCHEDULER_JOB_LOG
displays log information for all Scheduler jobs in the database.
USER_SCHEDULER_JOB_LOG
displays log information for the Scheduler jobs owned by the current user.
Column | Datatype | NULL | Description |
---|---|---|---|
LOG_ID |
NUMBER |
NOT NULL |
Unique identifier that identifies a row |
LOG_DATE |
TIMESTAMP(6) WITH TIME ZONE |
Date of the log entry | |
OWNER |
VARCHAR2(30) |
Owner of the Scheduler job | |
JOB_NAME |
VARCHAR2(30) |
Name of the Scheduler job | |
JOB_CLASS |
VARCHAR2(30) |
Class that the job belonged to at the time of entry | |
OPERATION |
VARCHAR2(30) |
Operation corresponding to the log entry | |
STATUS |
VARCHAR2(30) |
Status of the operation, if applicable | |
USER_NAME |
VARCHAR2(30) |
Name of the user who performed the operation, if applicable | |
CLIENT_ID |
VARCHAR2(64) |
Client identifier of the user who performed the operation, if applicable | |
GLOBAL_UID |
VARCHAR2(32) |
Global user identifier of the user who performed the operation, if applicable | |
ADDITIONAL_INFO |
CLOB |
Additional information on the entry, if applicable |