HOW TO FIX BROKEN JOBS

Step 1: Jobs that are currently running:


SELECT * FROM dba_jobs_running;



Step 2: Get the details of broken jobs


SELECT job FROM dba_jobs WHERE broken = ‘Y’;


col log_user for a30
select job,LOG_USER,BROKEN,FAILURES,LAST_SEC from dba_jobs


Step 3: If a job fails to successfully execute it will go into a broken state after 16 attempts. To reset, issue below command:


set serveroutput on


EXEC dbms_job.broken(jobno, FALSE);
  • March 19, 2016 | 15 views
  • Comments