VIEW: SYS.DBA_SCHEDULER_WINDOWS

Source

View Text - Preformatted

SELECT u.name, wo.name, w.res_plan,
    DECODE(bitand(w.flags,16),16,
      substr(w.schedule_expr,1,instr(w.schedule_expr,'"')-1),NULL),
    DECODE(bitand(w.flags,16),16,
      substr(w.schedule_expr,instr(w.schedule_expr,'"')+1,
        length(w.schedule_expr)-instr(w.schedule_expr,'"')) ,NULL),
    (CASE WHEN w.schedule_expr is null THEN 'ONCE'
       ELSE DECODE(bitand(w.flags,16+32),16,'NAMED',32,'CALENDAR',NULL) END),
    w.start_date,
    DECODE(bitand(w.flags,16),0,w.schedule_expr,NULL), w.end_date, w.duration,
    DECODE(w.priority,1,'HIGH',2,'LOW',NULL), w.next_start_date,
    w.actual_start_date,
    DECODE(bitand(w.flags, 1),0,'FALSE',1,'TRUE'),
    DECODE(bitand(w.flags,1+2),2,'TRUE',3,'TRUE','FALSE'),
    w.manual_open_time, w.manual_duration, w.comments
  FROM obj$ wo, user$ u, sys.scheduler$_window w
  WHERE w.obj# = wo.obj# AND wo.owner# = u.user#

View Text - HTML Formatted

SELECT U.NAME
, WO.NAME
, W.RES_PLAN
, DECODE(BITAND(W.FLAGS
, 16)
, 16
, SUBSTR(W.SCHEDULE_EXPR
, 1
, INSTR(W.SCHEDULE_EXPR
, '"')-1)
, NULL)
, DECODE(BITAND(W.FLAGS
, 16)
, 16
, SUBSTR(W.SCHEDULE_EXPR
, INSTR(W.SCHEDULE_EXPR
, '"')+1
, LENGTH(W.SCHEDULE_EXPR)-INSTR(W.SCHEDULE_EXPR
, '"'))
, NULL)
, (CASE WHEN W.SCHEDULE_EXPR IS NULL THEN 'ONCE' ELSE DECODE(BITAND(W.FLAGS
, 16+32)
, 16
, 'NAMED'
, 32
, 'CALENDAR'
, NULL) END)
, W.START_DATE
, DECODE(BITAND(W.FLAGS
, 16)
, 0
, W.SCHEDULE_EXPR
, NULL)
, W.END_DATE
, W.DURATION
, DECODE(W.PRIORITY
, 1
, 'HIGH'
, 2
, 'LOW'
, NULL)
, W.NEXT_START_DATE
, W.ACTUAL_START_DATE
, DECODE(BITAND(W.FLAGS
, 1)
, 0
, 'FALSE'
, 1
, 'TRUE')
, DECODE(BITAND(W.FLAGS
, 1+2)
, 2
, 'TRUE'
, 3
, 'TRUE'
, 'FALSE')
, W.MANUAL_OPEN_TIME
, W.MANUAL_DURATION
, W.COMMENTS
FROM OBJ$ WO
, USER$ U
, SYS.SCHEDULER$_WINDOW W
WHERE W.OBJ# = WO.OBJ#
AND WO.OWNER# = U.USER#