top of page
DBAGenesis_png.png

Find scheduler jobs in oracle

The below command will help you check Scheduler jobs that are configured inside database

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;

Become a top notch dba with DBA Genesis
Become a DBA with DBA Genesis.png
bottom of page