ALL_SCHEDULER_JOB_LOG
ALL_SCHEDULER_JOB_LOG displays log information for the Scheduler jobs accessible to the current user.
Related Views
-
DBA_SCHEDULER_JOB_LOGdisplays log information for all Scheduler jobs in the database. -
USER_SCHEDULER_JOB_LOGdisplays 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(128) |
Owner of the Scheduler job | |
JOB_NAME |
VARCHAR2(261) |
Name of the Scheduler job | |
JOB_SUBNAME |
VARCHAR2(261) |
Subname of the Scheduler job (for a chain step job) | |
JOB_CLASS |
VARCHAR2(128) |
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. Possible values for this column are dependent on the value in the
|
|
USER_NAME |
VARCHAR2(128) |
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 | |
CREDENTIAL_OWNER |
VARCHAR2(261) |
Owner of the credential used for this remote job run | |
CREDENTIAL_NAME |
VARCHAR2(261) |
Name of the credential used for this remote job run | |
DESTINATION_OWNER |
VARCHAR2(261) |
Owner of the destination object used in this remote job run; NULL if no object used | |
DESTINATION |
VARCHAR2(261) |
Destination for a remote job operation | |
ADDITIONAL_INFO |
CLOB |
Additional information on the entry, if applicable |
See Also: