Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR 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;
 
PREVIOUS NEXT
Tagged: #oracle #run #dates
ADD COMMENT
Topic
Name
8+5 =