The interval is 1 minute and is set correct. The job runs fine for a
couple of days and then all of a sudden it just stops to be executed.
There is nothing in the log for this job that shows anything wrong.
Andy Hassall wrote:
> 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 Wed Aug 23 2006 - 01:13:28 CDT
