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
8/22/2022 - Mon
Guy Hengel [angelIII / a3]
I would create, for each explicit month you want to run it, a schedule for the job, saying :
* first day of every 12 month
* start date: 1/x/2011
with x being the month you want the schedule to happen.
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
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.