ALL_SCHEDULER_JOB_RUN

3.52 ALL_SCHEDULER_JOB_RUN_DETAILS

ALL_SCHEDULER_JOB_RUN_DETAILS displays log run details for the Scheduler jobs accessible to the current user.

Related Views

DBA_SCHEDULER_JOB_RUN_DETAILS displays log run details for all Scheduler jobs in the database.
USER_SCHEDULER_JOB_RUN_DETAILS displays log run details for the Scheduler jobs owned by the current user.

Column	Datatype	NULL	Description
`LOG_ID`	`NUMBER`	`NOT NULL`	Unique identifier of the log entry (foreign key of the `*_SCHEDULER_JOB_LOG` views)
`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)
`STATUS`	`VARCHAR2(30)`		Status of the job run
`ERROR#`	`NUMBER`		Error number in the case of an error
`REQ_START_DATE`	`TIMESTAMP(6) WITH TIME ZONE`		Requested start date of the job run
`ACTUAL_START_DATE`	`TIMESTAMP(6) WITH TIME ZONE`		Actual date on which the job was run
`RUN_DURATION`	`INTERVAL DAY(3) TO SECOND(0)`		Duration of the job run
`INSTANCE_ID`	`NUMBER`		Identifier of the instance on which the job was run
`SESSION_ID`	`VARCHAR2(128)`		Session identifier of the job run
`SLAVE_PID`	`VARCHAR2(30)`		Process identifier of the slave on which the job was run
`CPU_USED`	`INTERVAL DAY(3) TO SECOND(2)`		Amount of CPU used for the job run
`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`	`VARCHAR2(4000)`		Additional information on the job run, if applicable
`ERRORS`	`VARCHAR2(4000)`		Error messages generated by this job run
`OUTPUT`	`VARCHAR2(4000)`		Output messages generated by this job run
`BINARY_ERRORS`	`BLOB`		Error messages generated by this job run in a binary format
`BINARY_OUTPUT`	`BLOB`		Binary output messages generated by this job run