RE: dbms_scheduler - run same job at different times

From: Jeff Chirco <JChirco_at_innout.com>
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-l

Received on Thu Aug 25 2011 - 14:46:19 CDT