Monday, 4 February 2013

How do I change a status of broken jobs from ‘Y’ to ‘N’


BEGIN
DBMS_JOB.BROKEN(job=>346,broken=>FALSE);
commit;
END;
/

(or)

exec sys.DBMS_JOB.BROKEN(job=>346,broken=>FALSE);
/
commit;
/