Skip Headers
Oracle® Database Reference
10g Release 2 (10.2)

Part Number B14237-04
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

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

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