VIEW: SYS.DBA_SCHEDULER_DESTS

Source

View Text - Preformatted

SELECT u.name, 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, user$ u, obj$ o
WHERE u.user# = o.owner# AND o.obj# = d.obj#
      and bitand(d.flags, 8) = 0

View Text - HTML Formatted

SELECT U.NAME
, 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
, USER$ U
, OBJ$ O WHERE U.USER# = O.OWNER#
AND O.OBJ# = D.OBJ#
AND BITAND(D.FLAGS
, 8) = 0