- 08 Sep, 2023
- 0 Comments
- 31 Secs Read
Find scheduler jobs in oracle
The below command will help you to check Scheduler jobs in the database :
SELECT JOB_NAME, STATE FROM DBA_SCHEDULER_JOBS where job_name=’RMAN_BACKUP’;
Query to check currently running scheduler jobs
All the DBA Scheduler jobs create logs. You can query below and check the details of
job logs :
1 | SELECT * FROM ALL_SCHEDULER_RUNNING_JOBS; |
1 2 3 4 5 6 7 | select log_id, log_date, owner, job_namefrom ALL_SCHEDULER_JOB_LOGwhere job_name like 'RMAN_B%' and log_date > sysdate-2;select log_id,log_date, owner, job_name, status, ADDITIONAL_INFOfrom ALL_SCHEDULER_JOB_LOGwhere log_id=113708; |