VIEW: SYS.USER_SCHEDULER_DESTS

Source

View Text - Preformatted

SELECT o.name,
  decode(bitand(d.flags, 2+4), 2, 'EXTERNAL', 4, 'DATABASE'),
  decode(bitand(d.flags, 1), 1, 'TRUE', 'FALSE'), d.comments
FROM scheduler$_destinations d, obj$ o
WHERE o.owner# = userenv('SCHEMAID') AND o.obj# = d.obj#
      and bitand(d.flags, 8) = 0

View Text - HTML Formatted

SELECT O.NAME
, DECODE(BITAND(D.FLAGS
, 2+4)
, 2
, 'EXTERNAL'
, 4
, 'DATABASE')
, DECODE(BITAND(D.FLAGS
, 1)
, 1
, 'TRUE'
, 'FALSE')
, D.COMMENTS FROM SCHEDULER$_DESTINATIONS D
, OBJ$ O WHERE O.OWNER# = USERENV('SCHEMAID')
AND O.OBJ# = D.OBJ#
AND BITAND(D.FLAGS
, 8) = 0