Execute Stored Procedure only on certain dates 1

[RJL1]

I have a need to schedule a StoreProcedure to run but only on the 15th of every month. I have the Store Procedure scheduled to run every day using the SQL Server agent under Jobs. However as stated I liek to chaneg this to run only on the 15th of every month. I know that within the job schedulers in SQL there is no option to pick the 15th of every month but is there a way to put it in the stored procedure that is the current day is equalto the 15th then run else do not execute?

I'm thinking this way I could have it run every day but it would only actually executeo when the day = the 15th

Thanks for any help

 

[gmmastros]

Put this at the top of your stored procedure:

If Day(GetDate()) <> 15 
	Return

-George
Microsoft SQL Server MVP
My Blogs
SQLCop
"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[RJL1]

gmmastros as always great solution. So simple it works great

Thanks

 

[dhulbert]

You can schedule jobs to run on any day of the month.

Go to your job, Edit the schedule, set the frequency to occurs monthly and then change it to the 15th of each month.





I love deadlines. I like the whooshing sound they make as they fly by
Douglas Adams
(1952-2001)