Table of Contents
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 :
Query 2: Find the scheduler job run Details:
SQL> select JOB_NAME,STATUS,RUN_DURATION from DBA_SCHEDULER_JOB_RUN_DETAILS where JOB_NAME='PURGE_LOG';
Query 3: Find the scheduler job log Details:
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 :
Query 4: Find the currently running job details :
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 :
