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(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

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