4.53 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