VIEW: SYS.USER_SCHEDULER_JOB_LOG

Source

View Text - Preformatted

(SELECT
     LOG_ID, LOG_DATE, 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, USER_NAME, CLIENT_ID, 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, '"'))),
     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 owner = SYS_CONTEXT('USERENV','CURRENT_USER'))

View Text - HTML Formatted

(SELECT LOG_ID
, LOG_DATE
, 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
, USER_NAME
, CLIENT_ID
, 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
, '"')))
, 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 OWNER = SYS_CONTEXT('USERENV'
, 'CURRENT_USER'))