RE: DBMS_JOB

Is it possible to catch exception from DBMS_JOB? If so, please explain to me.
Becuase we are submiting job thro' application which is in Forms. So after submiting user will be informed that job has been submited. It will execute usually in the night.

so in this case how to capture the exception?

Thank you for replying.

-----Original Message-----
From: Kresimir Fabijanic [mailto:kresimir_at_ozemail.com.au] Sent: 09 October 2000 13:30
To: Ramlal K Chithu; ORACLE-L_at_fatcity.com Cc: oracledba_at_quickdoc.co.uk
Subject: 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 - 03:34:40 CDT