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

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Mon, 21 Nov 2005 18:27:49 +0100
Message-ID: <43820397$0$4335$626a54ce@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 Received on Mon Nov 21 2005 - 11:27:49 CST