Re: DB jobs wont run for longer periods

nicklas.lundgren_at_triacon.se wrote:
> How do you mean, inside the procedure that is runned to see if there is
> something going wrong here? That is not the problem, if I look at the
> date when the job was runned I can see that it has been days since the
> last execution and this is job that should run every minute.

What does the following show you?

SQL> alter session set nls_date_format='DD-Mon-YY hh24:mi:ss';

Session altered.

SQL> select * from dba_jobs
where job=<job_number_in_question>;

HTH -g Received on Mon Aug 21 2006 - 09:09:41 CDT