Re: not allowing a job to run if it failed..

Your job is a plsql code, you can make jobs broken by calling a DBMS_JOB procedure somewhere in the exception handler. I think the procedure name is BROKEN() but it is easy to check. You might need another call to get the job id of your job. That will effectively prevent them from running.

Is that what you are looking for?

I cannot tell if there are any enhancements to the jobs in 9i worth checking

Regs
AK

NetComrade wrote:

> Is there are an easy way to do this (some parameter?)
>
> or should I work on a workaround (like a wrapper).
>
> when my jobs fail, i don't want them to rerun.
>
> Thanx.
> .......
> We use Oracle 8.1.7.3 on Solaris 2.7 boxes
> remove NSPAM to email
Received on Fri Sep 27 2002 - 02:57:39 CDT