DOYENSYS Knowledge Portal




We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal




Saturday, March 19, 2016

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);

No comments: