Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> dbms_jobs once an hour at the bottom of the hour
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? Received on Mon Nov 21 2005 - 10:33:54 CST
![]() |
![]() |