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: DB jobs wont run for longer periods

Re: DB jobs wont run for longer periods

From: DA Morgan <damorgan_at_psoug.org>
Date: Mon, 21 Aug 2006 08:49:26 -0700
Message-ID: <1156175366.299508@bubbleator.drizzle.com>


nicklas.lundgren_at_triacon.se wrote:
> Hi
>
> I have a job that should run every minute, this works fine for a while
> but then all of a sudden it stops to be executed. The parameter:
> job_queue_processes is set to 10 and I have only six jobs. If I run
> this job manually it then runs for one or two days but then it just
> stops to be executed again.
> This is a Oracle 9.2.0.1 database.
>
> Can anybody help me, that would really be appriciated.

Just a thought ... why in 9.2.0.1? Oracle has released a rather substantial number of meaningful patches in the last 5 years. I would suggest patching up to at least 9.2.0.6 at a minimum.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Mon Aug 21 2006 - 10:49:26 CDT

Original text of this message

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