Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Restart DBMS_JOBS

Re: Restart DBMS_JOBS

From: DA Morgan <damorgan_at_psoug.org>
Date: Thu, 02 Feb 2006 12:06:43 -0800
Message-ID: <1138910802.636171@jetspin.drizzle.com>


Ben de Boer wrote:
> Hi everybody,
> We run an Oracle database Version 8.1.7.2.0 on a unix machine.
> For some jobs to run we use DBMS_JOBS.SUBMIT ...
> Now sometimes, special for short running programs, it will be started a
> second time,
> after finishing without errors.
> Does anybody has some same problems and solved it.
> It would be very helpfull, if I know what I can do about it.
> I searched this problem also on Meta-link. It is known, but no solution was
> given.
>
> Tnx in advance
>
> Ben

My first thought is that you Oracle version is in desupport and you are missing two patches ... get yourself to at least 8.1.7.4 and then see if the issue continues to exist.

A move to 9.2+ would enhance both your performance and your resume.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Thu Feb 02 2006 - 14:06:43 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US