H-SC
asked on
Schedule job for specific months
I have a job on sql2005 that needs to run on the 1st day of a few selected months. I noticed that there is not an option for this in the schedule area of setting up a job. How can this be done?
ASKER
angeliii,
Many thanks for the fast response...I am trying to understand,
So I need the schedule to run on day 1 of the following months:
January, April, July and October
I would create a seperate schedule for each?
Many thanks for the fast response...I am trying to understand,
So I need the schedule to run on day 1 of the following months:
January, April, July and October
I would create a seperate schedule for each?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
perfect! Yes I orig. had it set for 1 schedule running first day every three, but the July one did not fire for some reason, so I was looking for a way to static the schedule for specific months. I will try both and see what happens! Many thanks again for your help..
* first day of every 12 month
* start date: 1/x/2011
with x being the month you want the schedule to happen.