VIEW: SYS.ALL_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.type# = 66 and e.dbid is null
   AND ( e.owner = SYS_CONTEXT('USERENV','CURRENT_USER')
         or  /* user has object privileges */
            ( select jo.obj# from obj$ jo, user$ ju where
                DECODE(instr(e.NAME,'"'),0, e.NAME,substr(e.NAME,1,instr(e.NAME,'"')-1)) = jo.name
                and e.owner = ju.name and jo.owner# = ju.user#
                and jo.subname is null and jo.type# = 66
            ) in
            ( select oa.obj#
                from sys.objauth$ oa
                where grantee# in ( select kzsrorol from x$kzsro )
            )
         or /* user has system privileges */
            (exists ( select null from v$enabledprivs
                       where priv_number = -265 /* CREATE ANY JOB */
                   )
             and e.owner!='SYS')
        )
  )

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.TYPE# = 66
AND E.DBID IS NULL
AND ( E.OWNER = SYS_CONTEXT('USERENV'
, 'CURRENT_USER') OR /* USER HAS OBJECT PRIVILEGES */ ( SELECT JO.OBJ#
FROM OBJ$ JO
, USER$ JU WHERE DECODE(INSTR(E.NAME
, '"')
, 0
, E.NAME
, SUBSTR(E.NAME
, 1
, INSTR(E.NAME
, '"')-1)) = JO.NAME
AND E.OWNER = JU.NAME
AND JO.OWNER# = JU.USER#
AND JO.SUBNAME IS NULL
AND JO.TYPE# = 66 ) IN ( SELECT OA.OBJ#
FROM SYS.OBJAUTH$ OA
WHERE GRANTEE# IN ( SELECT KZSROROL
FROM X$KZSRO ) ) OR /* USER HAS SYSTEM PRIVILEGES */ (EXISTS ( SELECT NULL
FROM V$ENABLEDPRIVS
WHERE PRIV_NUMBER = -265 /* CREATE ANY JOB */ )
AND E.OWNER!='SYS') ) )