This content has been marked as final. Show 10 replies
user457357 wrote:So you want a job to run once a year, and you want it to run for 2 and a half months?
How can I setup a scheduler job to run every year from june 15th to aug 31?
I doubt it. What do you really want? Please clarify.
No not just once but to continually run during june 15 to aug 13
Example to have it run
2013 from june 15th through aug 30th
2014 from june 15th through aug 30th
2015 from june 15th through aug 30th
2016 from june 15th through aug 30th
2017 from june 15th through aug 30th
2018 from june 15th through aug 30th
2019 from june 15th through aug 30th
You just repeated the same thing. Why would you want a job to run continuously for so long? What takes 2 and a half months of processing? And how will you know when it is done? Or do you mean to stop it on August 30th whether it is done or not?
I still think you aren't telling us what you really want it to do.
Do you really mean that you want it to run daily from June 15th to August 30th? Or maybe you really mean that you want it to run every hour from June 15th to August 30th. Or every 5 minutes?
Instead of me guessing, why don't you be a little more specific.
sorry meant to add the daily part to it.
basically I want to do
freq=yearly; bymonth=june,july,aug; byday=mon,tue,wed,thu,fri;
but have this start every year on june 15th and end on aug31
I would just run it daily. Then in the package, the first thing it would do is ask, "Is the current date between June 15th and August 31st?" If so, then continue with processing. If not, then end.
I know there are work around's but am wondering how to do it in the scheduler. I know I can create another basically empty scheduler that runs daily from june 1st to the 14th and then use the exclude functionality when setting up my job but would like to be able to do this with one job.
Use a repeat_interval like this:
and if you just wanted weekdays during that period, you could also add to it:
Thank you will give that a try.
Thanks, explained well
Edited by: Reena on Mar 28, 2013 4:58 PM