Re: waking up Oracle Jobs

Hi,

have you checked your interval expression? If it is like 'sysdate+1' then you rewrite the next_date by manually executing a job. Next_date is recalculated using interval expression every time you job runs.
Try this:

execute dbms_job.next_date(job,sysdate); execute dbms_job.interval(job,'trunc(sysdate+1)+1/6');

kai

• Sent from AltaVista http://www.altavista.com Where you can also find related Web Pages, Images, Audios, Videos, News, and Shopping. Smart is Beautiful