Re: DB jobs wont run for longer periods

Hi gazzag

One of my collegues has runned the job this morning so right now this job is running as it is supposed to do.

This is the complete queue:

SQL> select JOB,LAST_DATE,LAST_SEC,NEXT_DATE,NEXT_SEC,BROKEN,INTERVAL from dba_jobs;

       JOB LAST_DATE LAST_SEC NEXT_DATE NEXT_SEC BROKEN INTERVAL

---------- ----------- -------- ----------- -------- ------
--------------------------------------------------------------------------------
        61 21-08-2006  16:03:15 21-08-2006  16:04:15 N      sysdate+


(1/(24*60))

        62 08-08-2006  20:00:10 22-08-2006  20:00:10 N      SYSDATE+14
        53 21-08-2006  04:00:05 22-08-2006  04:00:00 N
trunc(sysdate)+1+(1/24)*4
        63 20-08-2006  19:03:13 21-08-2006  19:03:13 N      sysdate+1
       121 20-08-2006  19:00:39 21-08-2006  19:00:00 N
trunc(sysdate)+1+19/24
       122 21-08-2006  16:27:00 21-08-2006  16:29:00 N
sysdate+2/1440
        51 21-08-2006  16:27:57 21-08-2006  16:28:57 N      sysdate +


(1/(24*60))

       181 21-08-2006  11:06:16 21-08-2006  13:08:33 N      null

If you look at theese in notepad they should format just fine.

The jobs that sometimes stop are 51,61 and 122. The rest of the jobs runs fine. Received on Mon Aug 21 2006 - 09:31:22 CDT