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?
Microsoft SQL Server
Last Comment
H-SC
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
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
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.