RE: dbms_scheduler - run same job at different times
- From: Jeff Chirco <JChirco@xxxxxxxxxx>
- To: Morten Egan <oracle@xxxxxxxxxx>
- Date: Thu, 25 Aug 2011 19:46:19 +0000
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@xxxxxxxxx [mailto:anameofnoname@xxxxxxxxx] On Behalf Of
Morten Egan
Sent: Saturday, August 20, 2011 10:37 PM
To: Jeff Chirco
Cc: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxx<mailto:JChirco@xxxxxxxxxx>>
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
Other related posts:
