DB jobs wont run for longer periods

Giganews Newsgroups
Subject: DB jobs wont run for longer periods
Posted by:  nicklas.lundgr…@triacon.se
Date: 21 Aug 2006

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.

Replies