Post reply

sql agent

  • September 14, 2007 at 4:16 am

    #69967

    Is there any way to make sure that whenever sql server (2k) is restarted its sql server agent is also restarted automatically?

     

    thanks!

  • September 14, 2007 at 6:16 am

    #733729

    In SQL 2K, the Agent will not start automatically upon SQL startup, however you can set it to start automatically when the OS boots up. The best way to insure that they both start would be to write a batch file with the start service commands for both SQL and the Agent in it.

    Hope this helps.

  • September 14, 2007 at 6:26 am

    #733737

    Hi,

    What ever richard has suggested is the best way for you as there is no option to start it automatically.  

  • September 17, 2007 at 1:02 pm

    #734139

    I belive the closest you can come is this: On the general tab on the server propertys set the agent to restart when the OS starts.  Then on the advanced tab of the SQL Server Agent check Auto restart SQL Server Agent if it stops unexpectedly. 

    By doing this you should have it set up so that when the OS starts both SQL and SQL Agent come up.  Then as long as you don't deliberatly shut either the agent should re-start if either one stops unexpectedly.

    Then you could add in Richard's suggestion.  Its not ideal but that will probably be the best you can do.

    Kenneth Fisher

    Kenneth FisherI was once offered a wizards hat but it got in the way of my dunce cap.--------------------------------------------------------------------------------For better, quicker answers on T-SQL questions, click on the following... http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]For better answers on performance questions, click on the following... http://www.sqlservercentral.com/articles/SQLServerCentral/66909/[/url]Link to my Blog Post --> www.SQLStudies.com[/url]

  • September 17, 2007 at 10:24 pm

    #734212

    Thanks for your suggestions

    Best regards

Viewing 5 posts - 1 through 4 (of 4 total)

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