I always clean up my databases manually on Sundays. But at times, if need be, I clean it up on other days as well. However I never do it on Saturdays, since the traffic is usually the most on that day.
So here’s a simple tip using IF-ELSE to prevent my T-SQL code from running on Saturday’s, even if I run the code manually
IF DATEPART(dw,GETDATE())<> 7 -- 7 is Saturday, 1 is Sunday
-- YOUR T-SQL Code Comes Here
PRINT '*** Sorry This Code will Not Execute on Saturdays'
You may also want to read Make a T-SQL Query Sleep for a certain amount of time
Did you like this post?
|subscribe via rss||subscribe via e-mail|
|print this post||follow me on twitter|