VIEW: SYS.DBA_SCHEDULER_JOB_CLASSES

Source

View Text - Preformatted

SELECT u.name, co.name, c.res_grp_name,
    c.affinity ,
    DECODE(BITAND(c.flags,32+64+128+256),32,'OFF',64,'RUNS',128,'FAILED RUNS',
      256,'FULL',NULL),
    c.log_history, c.comments
  FROM obj$ co, user$ u, sys.scheduler$_class c
  WHERE c.obj# = co.obj# AND u.user# = co.owner#

View Text - HTML Formatted

SELECT U.NAME
, CO.NAME
, C.RES_GRP_NAME
, C.AFFINITY
, DECODE(BITAND(C.FLAGS
, 32+64+128+256)
, 32
, 'OFF'
, 64
, 'RUNS'
, 128
, 'FAILED RUNS'
, 256
, 'FULL'
, NULL)
, C.LOG_HISTORY
, C.COMMENTS
FROM OBJ$ CO
, USER$ U
, SYS.SCHEDULER$_CLASS C
WHERE C.OBJ# = CO.OBJ#
AND U.USER# = CO.OWNER#