Skip Headers
Oracle® Database Reference
11g Release 1 (11.1)

Part Number B28320-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
View PDF

ALL_SCHEDULER_JOB_LOG

ALL_SCHEDULER_JOB_LOG displays log information for the Scheduler jobs accessible to the current user.

Related Views

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(65)   Name of the Scheduler job
JOB_SUBNAME VARCHAR2(65)   Subname of the Scheduler job (for a chain step 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. 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

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
DESTINATION VARCHAR2(128)   Destination for a remote job operation
ADDITIONAL_INFO CLOB   Additional information on the entry, if applicable