VIEW: SYS.DBA_SCHEDULER_JOB_RUN_DETAILS

Source

View Text - Preformatted

(SELECT
     j.LOG_ID, j.LOG_DATE, e.OWNER,
     DECODE(instr(e.NAME,'"'),0, e.NAME,substr(e.NAME,1,instr(e.NAME,'"')-1)),
     DECODE(instr(e.NAME,'"'),0,NULL,substr(e.NAME,instr(e.NAME,'"')+1)),
     e.STATUS, j.ERROR#, j.REQ_START_DATE, j.START_DATE, j.RUN_DURATION,
     j.INSTANCE_ID, j.SESSION_ID, j.SLAVE_PID, j.CPU_USED,
     decode(e.credential, NULL, NULL,
        substr(e.credential, 1, instr(e.credential, '"')-1)),
     decode(e.credential, NULL, NULL,
        substr(e.credential, instr(e.credential, '"')+1,
           length(e.credential) - instr(e.credential, '"'))),
     decode(bitand(e.flags, 1), 0, NULL,
        substr(e.destination, 1, instr(e.destination, '"')-1)),
     decode(bitand(e.flags, 1), 0, e.destination,
        substr(e.destination, instr(e.destination, '"')+1,
           length(e.destination) - instr(e.destination, '"'))),
     j.ADDITIONAL_INFO,
     dbms_scheduler.get_varchar2_value(o.errors),
     dbms_scheduler.get_varchar2_value(o.output),
     o.ERRORS, o.OUTPUT
   FROM scheduler$_job_run_details j, scheduler$_event_log e,
     scheduler$_job_output o
   WHERE j.log_id = e.log_id AND j.log_id = o.log_id(+)
   AND e.dbid is null
   AND e.type# = 66)

View Text - HTML Formatted

(SELECT J.LOG_ID
, J.LOG_DATE
, E.OWNER
, DECODE(INSTR(E.NAME
, '"')
, 0
, E.NAME
, SUBSTR(E.NAME
, 1
, INSTR(E.NAME
, '"')-1))
, DECODE(INSTR(E.NAME
, '"')
, 0
, NULL
, SUBSTR(E.NAME
, INSTR(E.NAME
, '"')+1))
, E.STATUS
, J.ERROR#
, J.REQ_START_DATE
, J.START_DATE
, J.RUN_DURATION
, J.INSTANCE_ID
, J.SESSION_ID
, J.SLAVE_PID
, J.CPU_USED
, DECODE(E.CREDENTIAL
, NULL
, NULL
, SUBSTR(E.CREDENTIAL
, 1
, INSTR(E.CREDENTIAL
, '"')-1))
, DECODE(E.CREDENTIAL
, NULL
, NULL
, SUBSTR(E.CREDENTIAL
, INSTR(E.CREDENTIAL
, '"')+1
, LENGTH(E.CREDENTIAL) - INSTR(E.CREDENTIAL
, '"')))
, DECODE(BITAND(E.FLAGS
, 1)
, 0
, NULL
, SUBSTR(E.DESTINATION
, 1
, INSTR(E.DESTINATION
, '"')-1))
, DECODE(BITAND(E.FLAGS
, 1)
, 0
, E.DESTINATION
, SUBSTR(E.DESTINATION
, INSTR(E.DESTINATION
, '"')+1
, LENGTH(E.DESTINATION) - INSTR(E.DESTINATION
, '"')))
, J.ADDITIONAL_INFO
, DBMS_SCHEDULER.GET_VARCHAR2_VALUE(O.ERRORS)
, DBMS_SCHEDULER.GET_VARCHAR2_VALUE(O.OUTPUT)
, O.ERRORS
, O.OUTPUT
FROM SCHEDULER$_JOB_RUN_DETAILS J
, SCHEDULER$_EVENT_LOG E
, SCHEDULER$_JOB_OUTPUT O
WHERE J.LOG_ID = E.LOG_ID
AND J.LOG_ID = O.LOG_ID(+)
AND E.DBID IS NULL
AND E.TYPE# = 66)