ALL_SCHEDULER_JOB_LOG

Previous Next JavaScript must be enabled to correctly display this content

3.51 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(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 `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(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(128)`		Owner of the destination object used in this remote job run; NULL if no object used
`DESTINATION`	`VARCHAR2(128)`		Destination for a remote job operation
`ADDITIONAL_INFO`	`CLOB`		Additional information on the entry, if applicable

See Also: