Re: dbms_scheduler - run same job at different times

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>

> 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