Re: DB jobs wont run for longer periods

In article <1156164281.487419.3290_at_i42g2000cwa.googlegroups.com>, says...
> 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.
>
>

Check to see if it is BROKEN:

select *
from user_jobs
where broken = 'Y';

A job will marked broken automatically IIRC after it fails to run successfully (i.e. without any unhandled exceptions) 15 times.

-- 
jeremy