Re: DBMS_JOB

Ramlal

If the conditions that cause job to fail are the same - whrite the exception handler for that error - if it is possible.

Regards

Kresimir Fabijanic

• Original Message ----- From: "Ramlal K Chithu" <TS2182_at_emirates.com> To: <ORACLE-L_at_fatcity.com> Cc: <oracledba_at_quickdoc.co.uk> Sent: Monday, October 09, 2000 3:57 PM Subject: DBMS_JOB

>
> Dear DBAs
> How are you doing?
>
> Here we have submited a job which will execute a procedure.
> We have made that job to run only once (i.e no next date).
>
> But we have noticed onething that if that submited job fails in the
middle.
> It keeps on trying to execute the same on next time. so when we correct
> that procedure, it is again submitted till it become success.
>
> How can we stop this?
>
> We need to submit the job only one time, whether it is success or fail.
> Is it possible?
>
>
> Thanks alot for spending some time....
>
> Please reply us ...
>
> Ramlal.
>
> --------
> If you're bored, then visit the list's website: http://www.lazydba.com
(updated daily)
> to unsubscribe, send a blank email to oracledba-unsubscribe_at_quickdoc.co.uk
> to subscribe send a blank email to oracledba-subscribe_at_quickdoc.co.uk
Received on Mon Oct 09 2000 - 04:29:50 CDT