SQL

oracle next run dates

SELECT OWNER, JOB_NAME, JOB_TYPE, LAST_START_DATE,
       LAST_RUN_DURATION, NEXT_RUN_DATE, STATE,
       REPEAT_INTERVAL
FROM DBA_SCHEDULER_JOBS
WHERE JOB_SUBNAME IS NULL
  AND NEXT_RUN_DATE IS NOT NULL
  AND STATE = 'SCHEDULED'
  AND NEXT_RUN_DATE < trunc(sysdate) + 1
ORDER BY NEXT_RUN_DATE;