List Job Schedules
--
-- List job schedules.
--
 
SET PAUSE ON
SET PAUSE 'Press Return to Continue'
SET HEADING ON
SET LINESIZE 300
SET PAGESIZE 60
COLUMN owner FORMAT A20
COLUMN schedule_name FORMAT A30
COLUMN start_date FORMAT A20
COLUMN repeat_interval FORMAT A20
COLUMN end_date FORMAT A20
COLUMN comments FORMAT A20
 
SELECT owner,
schedule_name,
start_date,
repeat_interval,
end_date,
comments
FROM   dba_scheduler_schedules
ORDER BY owner, schedule_name
/

Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License