scheduling SQL server to restart

  • Good point JDixon...

     

    MohammedU
    Microsoft SQL Server MVP

  • well...I assume that stopping and starting the services is a bandaid to resolve a memory leak or other performance issue...some effort should be put into investigating that;

    as far as repeating every 3 days, you simply create a task to execute once, and then set it to repeat every 72 hours. that's how you get it to repeat every 3 days.

    Lowell


    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Viewing 2 posts - 16 through 16 (of 16 total)

You must be logged in to reply to this topic. Login to reply