Re: dbms_jobs once an hour at the bottom of the hour

"Michel Cadot" <micadot{at}altern{dot}org> wrote in message news:43820397$0$4335$626a54ce_at_news.free.fr...
>
> "Oxnard" <shankeypNO_SPAM_at_comcast.net> a écrit dans le message de news:
> EZidne0k8OtraxzeRVn-tw_at_comcast.com...
> | aix 5.2
> | oracle 9.2.0.7
> |
> | Seems like it is very straight forward on how to get a job to start at
> the
> | top of the hour then start every hour after that.
> |
> | But I need to have the job start every 30 minutes after the hour and
> start
> | every hour after that. ie
> |
> | 00:30 job start
> | 01:30 job start
> | 02:30 job start
> |
> | etc.
> |
> | any ideas on how to do this with dbms_jobs?
> |
> |
>
> dbms_job.submit (..., next_date=>trunc(sysdate,'HH')+3/24/2,
> interval=>'trunc(sysdate,''HH'')+3/24/2',...);
>
> Regards
> Michel Cadot
>
>

How did you come up with this?
I see the trunc(sysdate,'HH') comes up with the current hour but the 3/24/2 is a mystery to me. Received on Mon Nov 21 2005 - 12:02:51 CST