VIEW: SYS.ALL_SCHEDULER_GLOBAL_ATTRIBUTE

Source

View Text - Preformatted

SELECT o.name, a.value
 FROM sys.obj$ o, sys.scheduler$_global_attribute a
 WHERE o.obj# = a.obj# AND BITAND(a.flags,1) != 1

View Text - HTML Formatted

SELECT O.NAME
, A.VALUE
FROM SYS.OBJ$ O
, SYS.SCHEDULER$_GLOBAL_ATTRIBUTE A
WHERE O.OBJ# = A.OBJ#
AND BITAND(A.FLAGS
, 1) != 1