top of page

Find scheduler jobs in oracle

List and manage scheduler jobs in Oracle databases.

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
Start your DBA career today
bottom of page