RE: dbms_scheduler - run same job at different times
Date: Thu, 25 Aug 2011 19:46:19 +0000
Message-ID: <6D9F00643B733E489E419CB485C96627103C5B_at_IRVMBX01.innout.corp>
I did that following this method but it doesn't work right. The job runs at 730, 930, and 1230 instead of 7, 930, and 12. Why would it do that?
begin
dbms_scheduler.create_schedule('LOAD_1', repeat_interval =>
'FREQ=DAILY;BYHOUR=7,12');
END;
/
begin
dbms_scheduler.create_schedule('LOAD_2', repeat_interval =>
'FREQ=DAILY;BYHOUR=9;BYMINUTE=30');
END;
/
begin
dbms_scheduler.create_schedule('LOAD_MAIN', repeat_interval =>
'LOAD_1, LOAD_2');
END;
/
From: anameofnoname_at_gmail.com [mailto:anameofnoname_at_gmail.com] On Behalf Of Morten Egan
Sent: Saturday, August 20, 2011 10:37 PM
To: Jeff Chirco
Cc: oracle-l_at_freelists.org
Subject: Re: dbms_scheduler - run same job at different times
Yes, that is possible
Create 2 different schedules (one for the 7 and 12 run, and one for the 9.30 run) and then include the 9.30 schedule into the 7,12 schedule using the INCLUDE statement:
FREQ=DAILY; BYHOUR=7,12; INCLUDE=my_other_schedules;
where "my_other_schedules" is a an already created schedule, containing other execution time, that does not fit into the general one.
2011/8/19 Jeff Chirco <JChirco_at_innout.com<mailto:JChirco_at_innout.com>>
Hi everybody. I have a particular job created using dbms_scheduler that currently runs once a day at 7am. But now I would like to run this same job at 7, 930, and 12. Is it possible to configure this for the one job or am I going to have to create a second one. I know how to set it to run at 7 and 12 because they are on the hour, but the 930 one I am thinking will have to be on its own job.
Let me know if this is possible.
Thanks for any help.
Jeff
-- Regards, Morten Egan http://www.dbping.com -- http://www.freelists.org/webpage/oracle-lReceived on Thu Aug 25 2011 - 14:46:19 CDT