Friday, March 30, 2012

How to scheule job to run last day of the month

What are the settings to get a sql server job to always run the last day of the month? This should be quite easy!

Thanks!

SQL2000?

if so,

on the schedule tab of the job, edit the schedule, or create a new one... on the schedule type, select recurring, then click the change button on the lower right hand side.

In the Occurs section, change to monthly. Then in the monthly section that you will see to the right select the lower radio button and change the first drop down list box to "Last", the second to "Day" of every 1 month.

Set the time, and away you go...

|||Thanks! This would make a nice addition to EM Help!

No comments:

Post a Comment