How To Find Scheduler Jobs In Oracle : Easy Guide

Query 1: Find Scheduler Job Details :

Issue the below commands to find scheduler jobs in Oracle :

select OWNER,JOB_NAME,START_DATE,ENABLED,NEXT_RUN_DATE,FAILURE_COUNT from dba_scheduler_jobs where JOB_NAME='PURGE_LOG';

Output :

SQL> select JOB_NAME,STATUS,RUN_DURATION from DBA_SCHEDULER_JOB_RUN_DETAILS where JOB_NAME='PURGE_LOG';

The DBA Scheduler jobs create logs. You can check the details of the logs by issuing the below command :

select log_id, log_date, owner, job_name from dba_scheduler_job_log where job_name like '%PURGE%';

Output :

Also, you can issue the below command to get the currently running job details :

SQL> select owner,JOB_NAME,ELAPSED_TIME from dba_scheduler_running_jobs;

I hope it helps!! Want more about Scheduler jobs in Oracle? Follow the Oracle Doc .

Related Oracle Related Articles :

Spread the love