VIEW: SYS.ALL_SCHEDULER_CHAIN_STEPS

Source

View Text - Preformatted

SELECT u.name, o.name, cs.var_name,
  DECODE(BITAND(cs.flags,4), 4,
    substr(cs.object_name,1,instr(cs.object_name,'"')-1), NULL),
  DECODE(BITAND(cs.flags,4), 4,
    substr(cs.object_name,instr(cs.object_name,'"')+1,
      length(cs.object_name)-instr(cs.object_name,'"')), NULL),
  DECODE(BITAND(cs.flags,8), 8,
    substr(cs.object_name,1,instr(cs.object_name,'"')-1), NULL),
  DECODE(BITAND(cs.flags,8), 8,
    substr(cs.object_name,instr(cs.object_name,'"')+1,
      length(cs.object_name)-instr(cs.object_name,'"')), NULL),
  cs.queue_owner, cs.queue_name, cs.queue_agent, cs.condition,
  cs.credential_owner, cs.credential_name, cs.destination,
  DECODE(BITAND(cs.flags,1),0,'FALSE',1,'TRUE'),
  DECODE(BITAND(cs.flags,2),0,'FALSE',2,'TRUE'),
  DECODE(BITAND(cs.flags,512),0,'FALSE',512,'TRUE'),
  DECODE(BITAND(cs.flags,64),0,'FALSE',64,'TRUE'),
  DECODE(BITAND(cs.flags,128),0,'FALSE',128,'TRUE'),
  DECODE(BITAND(cs.flags,8+16+32+1024+2048),8,'EVENT_SCHEDULE',16,'INLINE_EVENT',
  32,'SUBCHAIN',1040,'INLINE_FILE_WATCHER', 2056, 'FILE_WATCHER_SCHEDULE',
  'PROGRAM'), cs.timeout
  FROM obj$ o, user$ u, sys.scheduler$_step cs
  WHERE cs.oid = o.obj# AND u.user# = o.owner# AND
    (o.owner# = userenv('SCHEMAID')
       or o.obj# 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 in (-265 /* CREATE ANY JOB */,
                                       -266 /* EXECUTE ANY PROGRAM */ )
                 )
          and o.owner#!=0)
      )

View Text - HTML Formatted

SELECT U.NAME
, O.NAME
, CS.VAR_NAME
, DECODE(BITAND(CS.FLAGS
, 4)
, 4
, SUBSTR(CS.OBJECT_NAME
, 1
, INSTR(CS.OBJECT_NAME
, '"')-1)
, NULL)
, DECODE(BITAND(CS.FLAGS
, 4)
, 4
, SUBSTR(CS.OBJECT_NAME
, INSTR(CS.OBJECT_NAME
, '"')+1
, LENGTH(CS.OBJECT_NAME)-INSTR(CS.OBJECT_NAME
, '"'))
, NULL)
, DECODE(BITAND(CS.FLAGS
, 8)
, 8
, SUBSTR(CS.OBJECT_NAME
, 1
, INSTR(CS.OBJECT_NAME
, '"')-1)
, NULL)
, DECODE(BITAND(CS.FLAGS
, 8)
, 8
, SUBSTR(CS.OBJECT_NAME
, INSTR(CS.OBJECT_NAME
, '"')+1
, LENGTH(CS.OBJECT_NAME)-INSTR(CS.OBJECT_NAME
, '"'))
, NULL)
, CS.QUEUE_OWNER
, CS.QUEUE_NAME
, CS.QUEUE_AGENT
, CS.CONDITION
, CS.CREDENTIAL_OWNER
, CS.CREDENTIAL_NAME
, CS.DESTINATION
, DECODE(BITAND(CS.FLAGS
, 1)
, 0
, 'FALSE'
, 1
, 'TRUE')
, DECODE(BITAND(CS.FLAGS
, 2)
, 0
, 'FALSE'
, 2
, 'TRUE')
, DECODE(BITAND(CS.FLAGS
, 512)
, 0
, 'FALSE'
, 512
, 'TRUE')
, DECODE(BITAND(CS.FLAGS
, 64)
, 0
, 'FALSE'
, 64
, 'TRUE')
, DECODE(BITAND(CS.FLAGS
, 128)
, 0
, 'FALSE'
, 128
, 'TRUE')
, DECODE(BITAND(CS.FLAGS
, 8+16+32+1024+2048)
, 8
, 'EVENT_SCHEDULE'
, 16
, 'INLINE_EVENT'
, 32
, 'SUBCHAIN'
, 1040
, 'INLINE_FILE_WATCHER'
, 2056
, 'FILE_WATCHER_SCHEDULE'
, 'PROGRAM')
, CS.TIMEOUT
FROM OBJ$ O
, USER$ U
, SYS.SCHEDULER$_STEP CS
WHERE CS.OID = O.OBJ#
AND U.USER# = O.OWNER# AND (O.OWNER# = USERENV('SCHEMAID') OR O.OBJ# 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 IN (-265 /* CREATE ANY JOB */
, -266 /* EXECUTE ANY PROGRAM */ ) )
AND O.OWNER#!=0) )