VIEW: SYS.USER_SCHEDULER_PROGRAMS

Source

View Text - Preformatted

SELECT po.name,
  DECODE(bitand(p.flags,2+4+8+16+32+2048+4096+8192), 2,'PLSQL_BLOCK',
         4,'STORED_PROCEDURE', 32, 'EXECUTABLE', 2048, 'EXTERNAL_SCRIPT',
         4096, 'SQL_SCRIPT', 8192, 'BACKUP_SCRIPT', ''),
  p.action, p.number_of_args, DECODE(BITAND(p.flags,1),0,'FALSE',1,'TRUE'),
  DECODE(BITAND(p.flags,256),0,'FALSE','TRUE'),
  p.schedule_limit, p.priority, p.job_weight, p.max_runs,
  p.max_failures, p.max_run_duration,
  p.nls_env, p.comments
  FROM obj$ po, sys.scheduler$_program p
  WHERE po.owner# = USERENV('SCHEMAID') AND p.obj# = po.obj#

View Text - HTML Formatted

SELECT PO.NAME
, DECODE(BITAND(P.FLAGS
, 2+4+8+16+32+2048+4096+8192)
, 2
, 'PLSQL_BLOCK'
, 4
, 'STORED_PROCEDURE'
, 32
, 'EXECUTABLE'
, 2048
, 'EXTERNAL_SCRIPT'
, 4096
, 'SQL_SCRIPT'
, 8192
, 'BACKUP_SCRIPT'
, '')
, P.ACTION
, P.NUMBER_OF_ARGS
, DECODE(BITAND(P.FLAGS
, 1)
, 0
, 'FALSE'
, 1
, 'TRUE')
, DECODE(BITAND(P.FLAGS
, 256)
, 0
, 'FALSE'
, 'TRUE')
, P.SCHEDULE_LIMIT
, P.PRIORITY
, P.JOB_WEIGHT
, P.MAX_RUNS
, P.MAX_FAILURES
, P.MAX_RUN_DURATION
, P.NLS_ENV
, P.COMMENTS
FROM OBJ$ PO
, SYS.SCHEDULER$_PROGRAM P
WHERE PO.OWNER# = USERENV('SCHEMAID')
AND P.OBJ# = PO.OBJ#