Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Strange dbms_job problem

Re: Strange dbms_job problem

From: Michel Cadot <micadot_at_netcourrier.com>
Date: 2000/06/05
Message-ID: <8hfqls$2nfi$1@s2.feed.news.oleane.net>#1/1

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US