Answers for "oracle list next running jobs"

SQL

1

oracle list next running jobs

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;

Posted by: Guest on February-14-2022

Code answers related to "oracle list next running jobs"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Python

Javascript

Whatever

Shell/Bash

CSS

Html

PHP

SQL

Java

C#