Oracle

How to check scheduler jobs in Oracle

Below command will help you check Scheduler jobs which are con gured inside database

sql">SELECT JOB_NAME, STATE FROM DBA_SCHEDULER_JOBS where job_name='RMAN_BACKUP';

Query to check currently running scheduler jobs

SELECT * FROM ALL_SCHEDULER_RUNNING_JOBS;

All the DBA Scheduler jobs create logs. You can query below and check the details of job logs

select log_id, log_date, owner, job_name

from ALL_SCHEDULER_JOB_LOG

where job_name like 'RMAN_B%' and log_date > sysdate-2;

select log_id,log_date, owner, job_name, status, ADDITIONAL_INFO

from ALL_SCHEDULER_JOB_LOG

where log_id=113708;

 

READ ALSO
Ansible Interview Questions 5

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.