myorama
4/25/2017 - 9:22 AM

schedules for statspack.sql

SET lines 250
COL enabled FOR a8
COL last_start_date FOR a18
COL next_run_date FOR a18
SELECT owner, job_name, enabled, 
       to_char(last_start_date, 'YYYY-MM-DD HH24:MI:SS') last_date, 
       to_char(next_run_date, 'YYYY-MM-DD HH24:MI:SS') next_date
FROM dba_scheduler_jobs
WHERE owner = 'PERFSTAT' AND job_name LIKE 'SP_%';