📋Steps in this guide1/1

Find scheduler jobs in oracle

SELECT * FROM ALL_SCHEDULER_RUNNING_JOBS;

oracle configurationintermediate

by OracleDba

10 views

Overview

Code/Command (click line numbers to comment):

SELECT * FROM ALL_SCHEDULER_RUNNING_JOBS;

select log_id, log_date, owner, job_name
from ALL_SCHEDULER_JOB_LOG
where job_name like 'RMAN_B%' and log_date &gt; sysdate-2;

select log_id,log_date, owner, job_name, status, ADDITIONAL_INFO
from ALL_SCHEDULER_JOB_LOG
where log_id=113708;

Comments (0)

Please to add comments

No comments yet. Be the first to comment!