Re: Script to run the broken job

From: Somaskandan <somas2007_at_gmail.com>
Date: Thu, 11 Jun 2009 18:12:43 -0700 (PDT)
Message-ID: <01965222-1175-43ff-8845-044c440b32fd_at_y17g2000yqn.googlegroups.com>

On Jun 11, 11:21 am, Nag <naga.cha..._at_gmail.com> wrote:
> Anyone has a readily availiable  script to capture the broken job id
> and run it again.
>
> Thanks,
> Naga

Hope this is what you expect...

BEGIN
   FOR i IN (SELECT job FROM user_jobs WHERE broken='Y')    LOOP

        dbms_job.broken(i.job,false);
        dbms_job.run(i.job,true); -- to forcibly run, specify true

else false. default is false.

   END LOOP;
END; Thanks,
Soma Received on Thu Jun 11 2009 - 20:12:43 CDT