VIEW: SYS.USER_SCHEDULER_GROUPS

Source

View Text - Preformatted

SELECT o.name,
  decode(bitand(w.flags, 8+16), 0, 'WINDOW', 8, 'JOB', 16,
decode(bitand(w.flags, 4096+8192), 4096,'DB_DEST', 8192, 'EXTERNAL_DEST', 'UNKOWN_DEST')),
  DECODE(BITAND(w.flags,1),0,'FALSE',1,'TRUE'),
  (SELECT COUNT(*) FROM user_scheduler_group_members ugm WHERE
   ugm.group_name=o.name),
  w.comments
FROM obj$ o, scheduler$_window_group w
WHERE o.obj# = w.obj# AND o.owner# = USERENV('SCHEMAID')

View Text - HTML Formatted

SELECT O.NAME
, DECODE(BITAND(W.FLAGS
, 8+16)
, 0
, 'WINDOW'
, 8
, 'JOB'
, 16
, DECODE(BITAND(W.FLAGS
, 4096+8192)
, 4096
, 'DB_DEST'
, 8192
, 'EXTERNAL_DEST'
, 'UNKOWN_DEST'))
, DECODE(BITAND(W.FLAGS
, 1)
, 0
, 'FALSE'
, 1
, 'TRUE')
, (SELECT COUNT(*)
FROM USER_SCHEDULER_GROUP_MEMBERS UGM WHERE UGM.GROUP_NAME=O.NAME)
, W.COMMENTS FROM OBJ$ O
, SCHEDULER$_WINDOW_GROUP W WHERE O.OBJ# = W.OBJ#
AND O.OWNER# = USERENV('SCHEMAID')