Avatar of H-SC
H-SC
Flag for United States of America 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

Avatar of undefined
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

I would create a seperate schedule for each?
ASKER CERTIFIED SOLUTION
Guy Hengel [angelIII / a3]

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.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
H-SC

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..
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.
rwheeler23