Link to home
Create AccountLog in
Avatar of H-SC
H-SCFlag 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?
Avatar of Guy Hengel [angelIII / a3]
Guy Hengel [angelIII / a3]
Flag of Luxembourg image

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.
Avatar of 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
Avatar of Guy Hengel [angelIII / a3]
Guy Hengel [angelIII / a3]
Flag of Luxembourg image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of 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..