Post reply

SQL Server Agent Shuts down for for no reason

  • September 9, 2005 at 12:02 pm

    #165935

    For some reason the SQL Server Agent shuts down and doesn't restart even though its set to do so.  It either stops for no reason or stops when the server is rebooted and never restarts.

  • September 12, 2005 at 1:31 am

    #589019

    Try setting the Autorestart SQL Server Agent if it stops unexpectedly to true in the Properties of SQL Server Agent

     

    Sql Server Agent --> Properties --> advanced (tab) --> Restart Services

     

    HTH

    -Meghana

     

    Regards,

    Meghana

  • September 12, 2005 at 7:22 am

    #589051

    This option has already been set and has always been set to true when SQL Server Agent has stopped working and not restarted before. Are there any other possibilities or fixes?

  • September 12, 2005 at 9:46 pm

    #589221

    Bryan - here're a couple more things you could check out...

    1) Settings - Control Panel - Administrative tools - Services - Under SQLAgent properties - check "Recovery" tab for settings of -

    First failure

    Second failure

    Subsequent failures....

    - General tab - ensure that "Startup type" is set to "Automatic"

    2) In Enterprise Manager - SQL Server Properties (NOT SQL Server Agent) - General tab - Autostart SQL Server Agent.

    3) Look in the "Event Viewer" logs to see if there is any information logged there!







    **ASCII stupid question, get a stupid ANSI !!!**

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

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