How to create an Annual Job Schedule

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

SQL Server Administration (2008)

How to create an Annual Job Schedule

Author

Topic

mivey4
Yak Posting Veteran

66 Posts

Posted - 2010-01-25 : 13:31:09

Hi,

This may be a fairly simple question but since I've never had a need to perform this particular task before, I was looking for some input from anyone that can provide it.

I need to create a SQL schedule for a job that ONLY needs to execute in January of each year. After looking at my options within the job schedule agent, I don't see where I could easily create such a job.

Since this would be considered a recurring job, if I select that option then I am left with the options of DAILY, WEEKLY and MONTHLY. With the MONTHLY option being the closest to what I am looking for being ANNUALLY, if I select this option I see that I can try to get the results I am after by selecting every 13 months starting this January. But my concern is that after it executes it will being counting 13 months next time from February, which will skew the results I'm after.

Any suggestions anyone????

Oracle OCA
Adaptec ACSP

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2010-01-25 : 14:01:17

On the job schedule screen,

Set Frequency
Occurs -- Monthly
The FIRST DAY of every 12 Months

mivey4
Yak Posting Veteran

66 Posts

Posted - 2010-01-25 : 14:23:54

Thanks for the response russell. So the 1st day of every 12 months wouldn't land me in December?
I guess my dillema is when does the count start? If I set the job to the FIRST DAY of every 12 MONTHS, starting this month; based on what you're saying then the count start in the next month to land me at January of next year. Is this correct?

Otherwise, if I count 12 months starting from the current month; I'd expect that the job would execute on the 1st of December.

Oracle OCA
Adaptec ACSP

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2010-01-25 : 14:39:30

you can tell it when you want it to start -- look for the Start Date box in the duration section

mivey4
Yak Posting Veteran

66 Posts

Posted - 2010-01-25 : 14:41:12

Okay, thanks for the information!

Oracle OCA
Adaptec ACSP

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2010-01-25 : 14:47:21

You're welcome