Re: DB jobs wont run for longer periods

From: Robert Klemme <shortcutter_at_googlemail.com>
Date: Mon, 21 Aug 2006 16:33:14 +0200
Message-ID: <4ktuhaFdpjnqU1@individual.net>

On 21.08.2006 14:44, 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 to exclude the obvious: you didn't set an end date or other limit to the number of executions? Also, I assume other jobs are running fine, do they?

robert Received on Mon Aug 21 2006 - 09:33:14 CDT