Post reply

SQL Server Agent Restart Issue

  • December 30, 2004 at 10:25 am

    #361804

    We have a third party software that we need to restart SQL Server occasinally for it. But evertime when somebody forget to restart SQL Server Agent also while restart SQL Server, it caused us lots of troubles. Is there any way on the SQL Server System side that we can tie the SQL Server restart with the SQL Server Agent restart?

     

    Thanks in advance!

    Lu

  • January 3, 2005 at 8:00 am

    This was removed by the editor as SPAM

  • January 3, 2005 at 12:12 pm

    #535647

    Yes...Open Enterprise Manager. Right click on the server and choose Properties. At the bottom of the General tab, you can place a checkmark to 'Autostart SQL Server' and 'Autostart SQL Server Agent'.

    You can also right click on SQL Agent in the management of the server and choose properties. At the top of the Advanced tab, you can place checkmarks to 'Auto restart SQL Server if it stops unexpectedly' and 'Auto restart SQL Server Agent if it stops unexpectedly.'

    Hope this helps!



    Michelle

  • January 3, 2005 at 12:30 pm

    #535651

    I will certainly try it.

    Thanks a lot!

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

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