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 2005 Forums
 SSIS and Import/Export (2005)
 Schedule for last day of the month

Author  Topic 

masterdineen
Aged Yak Warrior

550 Posts

Posted - 2010-11-04 : 09:56:36
When setting a new job schedule.

I want to set a job to fire on the last day of the month, every month.

So by setting the frequency to 31 of every 1 month(s)

Will this fire off on the 30th on the rest of the months and the 28th for Feb?

MCTS / MCITP certified

robvolk
Most Valuable Yak

15732 Posts

Posted - 2010-11-04 : 10:01:00
There's options for "last" and "day" in the Monthly frequency settings, amongst others.
Go to Top of Page
   

- Advertisement -