DBA Data[Home] [Help] [Dependency Information]

VIEW: SYS.CDB_SCHEDULER_JOB_RUN_DETAILS

Object Details
Object Name: CDB_SCHEDULER_JOB_RUN_DETAILS
Object Type: VIEW
Owner: SYS
Subobject Name:
Status: VALID

The details of a job run in all containers

[View Source]

Columns
Name Datatype Length Mandatory Comments
LOG_ID NUMBER
Yes The unique id of the log entry. Foreign key on entry in dba_scheduler_job_log
LOG_DATE TIMESTAMP(6) WITH TIME ZONE (13)
The date of the log entry
OWNER VARCHAR2 (128)
The owner of the scheduler job
JOB_NAME VARCHAR2 (261)
The name of the scheduler job
JOB_SUBNAME VARCHAR2 (261)
The subname of the scheduler job (for a chain step job)
STATUS VARCHAR2 (30)
The status of the job run
ERROR# NUMBER

The error number in the case of error
REQ_START_DATE TIMESTAMP(6) WITH TIME ZONE (13)
The requested start date of the job run
ACTUAL_START_DATE TIMESTAMP(6) WITH TIME ZONE (13)
The actual date the job ran
RUN_DURATION INTERVAL DAY(3) TO SECOND(0) (11)
The duration that the job ran
INSTANCE_ID NUMBER

The id of the instance on which the job ran
SESSION_ID VARCHAR2 (128)
The session id of the job run
SLAVE_PID VARCHAR2 (30)
The process id of the slave on which the job ran
CPU_USED INTERVAL DAY(3) TO SECOND(2) (11)
The amount of cpu used for this job run
CREDENTIAL_OWNER VARCHAR2 (261)
Owner of the credential used for this external or remote job run
CREDENTIAL_NAME VARCHAR2 (261)
Name of the credential used for this external or remote job run
DESTINATION_OWNER VARCHAR2 (128)
Owner of destination object used in remote run or NULL if no object used
DESTINATION VARCHAR2 (128)
The destination for a remote job run
ADDITIONAL_INFO VARCHAR2 (4000)
Additional information on the job run, if applicable
ERRORS VARCHAR2 (4000)
Text representation in db character set of errors from this job run
OUTPUT VARCHAR2 (4000)
Text representation in db character set of output from this job run
BINARY_ERRORS BLOB (4000)
Errors from this job run, in their original form
BINARY_OUTPUT BLOB (4000)
Output from this job run, in its original form
CON_ID NUMBER

container id
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT LOG_ID
,      LOG_DATE
,      OWNER
,      JOB_NAME
,      JOB_SUBNAME
,      STATUS
,      ERROR#
,      REQ_START_DATE
,      ACTUAL_START_DATE
,      RUN_DURATION
,      INSTANCE_ID
,      SESSION_ID
,      SLAVE_PID
,      CPU_USED
,      CREDENTIAL_OWNER
,      CREDENTIAL_NAME
,      DESTINATION_OWNER
,      DESTINATION
,      ADDITIONAL_INFO
,      ERRORS
,      OUTPUT
,      BINARY_ERRORS
,      BINARY_OUTPUT
,      CON_ID
FROM SYS.CDB_SCHEDULER_JOB_RUN_DETAILS;

Dependencies

[top of page]

SYS.CDB_SCHEDULER_JOB_RUN_DETAILS does not reference any database object

SYS.CDB_SCHEDULER_JOB_RUN_DETAILS is referenced by following:

SchemaPUBLIC
SynonymCDB_SCHEDULER_JOB_RUN_DETAILS