Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: DBMS_JOB
Ramlal,
You must be submitting a backend routine for execution as a job. Why don't
you trap the exceptions in the routine itself. You can insert the requisite
messages in an error table which you can verify the next day after the job
has completed. This way, no untrapped exceptions are generated forcing
oracle to re-execute.
Thanks,
Amar
00-971-50-7883254
ts2017_at_emirates.com
amar_padhi_at_hotmail.com
amar_padhi_at_musclemail.com
-----Original Message-----
From: Ramlal K Chithu [mailto:TS2182_at_emirates.com]
Sent: Monday, October 09, 2000 12:35 PM
To: 'Kresimir Fabijanic'; ORACLE-L_at_fatcity.com
Cc: oracledba_at_quickdoc.co.uk
Subject: 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
>
> 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
>
>
![]() |
![]() |