Query to find the registered and scheduled Jobs in Oracle DB
SELECT job, log_user username, what,
TO_CHAR(next_date, 'DD-MON-YYYY HH24:MI:SS') Next_Run, interval,
TO_CHAR(last_date, 'DD-MON-YYYY HH24:MI:SS') last_Run, failures, broken
FROM dba_jobs;
No comments:
Post a Comment