Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-04 |
|
|
PDF · Mobi · ePub |
ALL_SCHEDULER_JOB_RUN_DETAILS
displays log run details for the Scheduler jobs accessible to the current user.
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 |