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

VIEW: SYS.ALL_SCHEDULER_JOB_RUN_DETAILS

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

[View Source]

Columns
Name Datatype Length Mandatory Comments
LOG_ID NUMBER
Yes
LOG_DATE TIMESTAMP(6) WITH TIME ZONE (13)
OWNER VARCHAR2 (128)
JOB_NAME VARCHAR2 (261)
JOB_SUBNAME VARCHAR2 (261)
STATUS VARCHAR2 (30)
ERROR# NUMBER

REQ_START_DATE TIMESTAMP(6) WITH TIME ZONE (13)
ACTUAL_START_DATE TIMESTAMP(6) WITH TIME ZONE (13)
RUN_DURATION INTERVAL DAY(3) TO SECOND(0) (11)
INSTANCE_ID NUMBER

SESSION_ID VARCHAR2 (128)
SLAVE_PID VARCHAR2 (30)
CPU_USED INTERVAL DAY(3) TO SECOND(2) (11)
CREDENTIAL_OWNER VARCHAR2 (261)
CREDENTIAL_NAME VARCHAR2 (261)
DESTINATION_OWNER VARCHAR2 (128)
DESTINATION VARCHAR2 (128)
ADDITIONAL_INFO VARCHAR2 (4000)
ERRORS VARCHAR2 (4000)
OUTPUT VARCHAR2 (4000)
BINARY_ERRORS BLOB (4000)
BINARY_OUTPUT BLOB (4000)
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
FROM SYS.ALL_SCHEDULER_JOB_RUN_DETAILS;

Dependencies

[top of page]

SYS.ALL_SCHEDULER_JOB_RUN_DETAILS references the following:

SchemaSYS
PL/SQL PackageDBMS_SCHEDULER - show dependent code
TableOBJ$
TableOBJAUTH$
TableSCHEDULER$_EVENT_LOG
TableSCHEDULER$_JOB_OUTPUT
TableSCHEDULER$_JOB_RUN_DETAILS
TableUSER$
SYS.ALL_SCHEDULER_JOB_RUN_DETAILS is referenced by following:

SchemaPUBLIC
SynonymALL_SCHEDULER_JOB_RUN_DETAILS