sysdate+1 means sysdate plus one day not plus one hour.
You have to use sysdate+1/24.
--
Have a nice day
Michel
<sascha_kiefer_at_my-deja.com> a écrit dans le message : 8hfn22$ing$1_at_nnrp1.deja.com...
> Hi,
>
> I tried to creat a job, that runs every hour.
> I used the following statements:
>
> variable :jobnr number
>
> begin
> dbms_job.submit (:jobnr, 'Pik_Bbm_Ebna_Utils01001.CreateYesterdayLog;',
> sysdate, 'sysdate+1');
> commit;
> end;
>
> normally it should run directly and then every hour.
> In the table user_job the entry is correct, but the job dosen't work.
>
> When I use dbms_job.run (22) the program does what I expect.
>
> What's wrong ?
>
> Thanks
> Sascha
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Mon Jun 05 2000 - 00:00:00 CDT
