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_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(65)`		Name of the Scheduler job
`JOB_SUBNAME`	`VARCHAR2(65)`		Subname 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)`		The possible values for this column are dependent on the value in the `OPERATION` column. In most cases `STATUS` will be empty (null). Only for job run operations will it have a value. `STATUS` will be empty (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
`ADDITIONAL_INFO`	`CLOB`		Additional information on the entry, if applicable