VIEW: SYS.ALL_SCHEDULER_JOB_LOG

Source

View Text - Preformatted

(SELECT
     e.LOG_ID, e.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)),
     co.NAME, OPERATION, e.STATUS, e.USER_NAME, e.CLIENT_ID, e.GUID,
     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, '"'))),
     e.ADDITIONAL_INFO
   FROM scheduler$_event_log e, obj$ co
   WHERE e.type# = 66 and e.dbid is null and e.class_id = co.obj#(+)
   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 E.LOG_ID
, E.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))
, CO.NAME
, OPERATION
, E.STATUS
, E.USER_NAME
, E.CLIENT_ID
, E.GUID
, 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
, '"')))
, E.ADDITIONAL_INFO
FROM SCHEDULER$_EVENT_LOG E
, OBJ$ CO
WHERE E.TYPE# = 66
AND E.DBID IS NULL
AND E.CLASS_ID = CO.OBJ#(+)
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') ) )