scheduling SQL server to restart

• MohammedU

  SSCoach

  Points: 19644

  More actions

  December 5, 2006 at 4:04 pm

  #676081

  Good point JDixon...

   

  MohammedU
  Microsoft SQL Server MVP

• Lowell

  SSC Guru

  Points: 323527

  More actions

  December 5, 2006 at 6:22 pm

  #676106

  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!