Re: DB jobs wont run for longer periods

From: Andy Hassall <andy_at_andyh.co.uk>
Date: Wed, 23 Aug 2006 00:28:32 +0100
Message-ID: <c84ne21c9s49pp0prna3r9lq554ukpibca@4ax.com>

On 21 Aug 2006 05:44:41 -0700, nicklas.lundgren_at_triacon.se wrote:

>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.

What's the interval expression for the job? Could the job be attempting to set a next_date in the past? You'll get an entry in the alert log for this.

-- 
Andy Hassall :: andy@andyh.co.uk :: http://www.andyh.co.uk
http://www.andyhsoftware.co.uk/space :: disk and FTP usage analysis tool

Received on Tue Aug 22 2006 - 18:28:32 CDT