| Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-03  | 
  | 
  | 
View PDF | 
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 | 
Unique identifier of the log entry | |
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 | |
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(30) | 
Session identifier of the job run | |
SLAVE_PID | 
VARCHAR2(30) | 
Process identifier of the slave on which the job was run | |
CPU_USED | 
NUMBER | 
Amount of CPU used for the job run | |
ADDITIONAL_INFO | 
VARCHAR2(4000) | 
Additional information on the job run, if applicable |