| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: DBMS_JOB
Hi Oweson,
If you have submitted the job along with the interval parameter, then it
will execute in a loop. You can remove the job using dbms_job.remove(id) and
submit a new job.
You job will keep on getting performed at a regular interval unless you remove it from the job log, irrespective of whether the called procedure is recreated or dropped etc.
I would suggest that you create an error_table and insert rows into it from the routines being executed through dbms_job, when ever an error is encountered. Trap errors in the exception block. You can then verify this table at a regular interval to check on the errors.
Thanks,
Amar
00-971-50-7883254
ts2017_at_emirates.com
amar_padhi_at_hotmail.com
amar_padhi_at_musclemail.com
-----Original Message-----
From: Oweson Flynn [mailto:Oweson.Flynn_at_liberty.co.za]
Sent: Monday, October 09, 2000 1:52 PM
To: ORACLE-L; Amar Kumar Padhi
Subject: Re: DBMS_JOB
Hi Amar,
I was interested to read your reply, as I am experiencing a similar sort of problem with DBMS_JOB at the moment.
<background>
I have a system that uses the PLSQL cartridge extensively. If you run a
procedure that runs for a long time (in excess of 3 minutes) the browser
times out. However, the procedure will finish executing normally, but you
cannot view the HTML output.
Basically, I have written a package which will allow you to submit a job (for the PLSQL cartridge) to DBMS_JOB from your browser. The package will then use DBMS_JOB to run the job, and then it will save the HTML output from the job to a table.
You can then view the HTML at your convenience.
(there are procedures to assist in all the maintenance functionality of adding / viewing / deleting / monitoring the status of jobs in it, but that is not relevant here).
The nice feature of this package it that it will allow the user to submit a
job to run either interactively, or to be subitted to run in 'batch' mode
with no changes to the code at all!
</background>
Unfortunately, if there is a problem submitting the job (e.g., the 'run job' schema does not have permission to run the procedure), there is no exception raised (that I can see). How can I trap / see if and when there are errors submitting the job, or when the job executes?
Any ideas would be appreciated.
Regards
Oweson Flynn
(Karen Turnbull, please contact me)
>
> 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-----
> Sent: Monday, October 09, 2000 12:35 PM
> To: 'Kresimir Fabijanic'; ORACLE-L_at_fatcity.com
> Cc: oracledba_at_quickdoc.co.uk
>
>
>
> 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-----
> Sent: 09 October 2000 13:30
> To: Ramlal K Chithu; ORACLE-L_at_fatcity.com
> Cc: oracledba_at_quickdoc.co.uk
>
>
> 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 -----
> To: <ORACLE-L_at_fatcity.com>
> Cc: <oracledba_at_quickdoc.co.uk>
> Sent: Monday, October 09, 2000 3:57 PM
>
>
> >
> > 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
> >
> >
>
> --------
> 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
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Amar Kumar Padhi
> INET: TS2017_at_emirates.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
>
This message may contain information which is confidential and subject to legal privilege. If you are not the intended recipient, you may not peruse, use, disseminate, distribute or copy this message. If you have received this message in error, please notify the sender immediately by email, facsimile Received on Mon Oct 09 2000 - 23:11:35 CDT
 |
 |