Re: Script to run the broken job

From: Somaskandan <>
Date: Thu, 11 Jun 2009 18:12:43 -0700 (PDT)
Message-ID: <>

On Jun 11, 11:21 am, Nag <> 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...

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

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

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

Original text of this message