Post reply

SQL Server Agent Restart.

  • April 26, 2017 at 4:48 am

    #342613

    I have a problem on some servers of SQL Agent not restarting automatically.
    What is teh differance between teh properties as available via SSMS - (below 2)  and configuring it vai control panel admin tools, services (below 1). When I google I seem to get directed to set one or the other - and dont really understand how the two differant things do or do not affect each other? Any help greatfully recived. Thanks

  • April 26, 2017 at 7:03 am

    #1939944

    The services app (and configuration manager) have the start modes of the services themselves. The start mode applies to when the server itself starts up.
    The settings on the property page for SQL Server agent applies to when the service just stops unexpectedly as it says. It doesn't stop unexpectedly very often (anymore) but something like a memory leak within the agent process could cause Agent to stop unexpectedly. This does not include things such as a server restart, manually stopping the service.So when you do windows patching and need Agent to be running after the server is restarted, the service start mode needs to be automatic.
    If you do use Agent and need it to be running, most people have the service set to automatic start mode and both of the options on the properties page selected.

    Sue

  • April 26, 2017 at 7:12 am

    #1939949

    Sue_H - Wednesday, April 26, 2017 7:03 AM

    The services app (and configuration manager) have the start modes of the services themselves. The start mode applies to when the server itself starts up.
    The settings on the property page for SQL Server agent applies to when the service just stops unexpectedly as it says. It doesn't stop unexpectedly very often (anymore) but something like a memory leak within the agent process could cause Agent to stop unexpectedly. This does not include things such as a server restart, manually stopping the service.So when you do windows patching and need Agent to be running after the server is restarted, the service start mode needs to be automatic.
    If you do use Agent and need it to be running, most people have the service set to automatic start mode and both of the options on the properties page selected.

    Sue

    Thanks very much Sue.

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

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