VIEW: SYS.ALL_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 co.owner# = u.user# AND
    (co.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 (-267, /* EXECUTE ANY CLASS */
                                       -268  /* MANAGE SCHEDULER */ )
                 )
      )

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 CO.OWNER# = U.USER# AND (CO.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 (-267
, /* EXECUTE ANY CLASS */ -268 /* MANAGE SCHEDULER */ ) ) )