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.
Unique identifier that identifies a row
TIMESTAMP(6) WITH TIME ZONE
Date of the log entry
Owner of the Scheduler job
Name of the Scheduler job
Subname of the Scheduler job (for a chain step job)
Class that the job belonged to at the time of entry
Operation corresponding to the log entry
Status of the operation, if applicable. Possible values for this column are dependent on the value in the OPERATION column. In most cases, STATUS will be NULL. Only for job run operations will it have a value.
STATUS will be NULL when OPERATION is one of the following:
CREATE - Job was created
UPDATE - One or more job attributes have been modified
ENABLE - Job has been enabled
DISABLE - Job has been disabled
COMPLETED - For repeating jobs only, job has reached its end date or maximum number of runs
BROKEN - Job has reached its maximum number of failures
STATUS can be SUCCEEDED (job run completed successfully), FAILED (job run failed), or STOPPED (job run was stopped) when OPERATION is one of the following:
RUN - Regular job run
RETRY_RUN - Job is being retried because the previous run resulted in an error and RESTARTABLE is set to TRUE
RECOVERY_RUN - Job is being rerun because the database went down, or the job slave crashed and RESTARTABLE is set to TRUE
Name of the user who performed the operation, if applicable
Client identifier of the user who performed the operation, if applicable
Global user identifier of the user who performed the operation, if applicable
Destination for a remote job operation
Additional information on the entry, if applicable