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

"Oxnard" <shankeypNO_SPAM_at_comcast.net> a écrit dans le message de news: _6ydnafyjZ5Slh_enZ2dnUVZ_sydnZ2d_at_comcast.com...
|
| "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.
|
|

Well, 1 is a day, 1/24 is one hour, 3/24/2 is 1.5 hour. So truncating to the hour and adding 1.5 hour give me 30 minutes after the next hour.

Regards
Michel Cadot Received on Mon Nov 21 2005 - 12:44:15 CST