Results 1 to 8 of 8

Thread: SQL Server Agent did not auto-start

  1. #1
    Join Date
    Oct 2007
    Posts
    7

    SQL Server Agent did not auto-start

    Hello everyone! We had an issue this week where SQL Server Agent did not restart automatically. Weekly maintenance runs on the server each Sunday in which a reboot of the server occurs. Both SQL Server and SQL Server Agent are set to auto-start when OS starts. SQL started fine, but SQL Server Agent didn't.

    Anyone know of a reason why SQL Server Agent wouldn't have restarted? Also, does anyone know of a way to set something up that would alert me (through email) if this service hasn't restarted?

    Thanks in advance,
    Lance

  2. #2
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,922
    Check SQL Agent and SQL Server error logs as well as Windows event logs.

  3. #3
    Join Date
    Oct 2007
    Posts
    7
    Thanks! I've looked at both the event logs and SQL logs, but I'm not seeing any errors that would have prevented Agent from starting. I do see where they rebooted the server three times yesterday. The first two times, Agent restarted as normal, but the third time it didn't.

  4. #4
    Join Date
    Sep 2002
    Posts
    5,938
    Checked sql agent error log? Should have entries in it and windows app event log if service failed to start. To send alert, you need windows monitoring tool.

  5. #5
    Join Date
    Oct 2007
    Posts
    7
    Hmmm, well I thought I had checked the Agent error log. Maybe I had only checked the SQL logs. Let me go find it. Thanks.

  6. #6
    Join Date
    Oct 2007
    Posts
    7
    Ahh, finally found an error in the system section of the event log.
    "The SQLSERVERAGENT service failed to start due to the following error:
    The service did not respond to the start or control request in a timely fashion. "

    Now, to find out why it didn't respond.

  7. #7
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,922
    Check if it has dependency set on MSSQLServer service, normally it should.

  8. #8
    Join Date
    Oct 2007
    Posts
    7
    Hello! Thanks for the help. Yes, dependency is set upon MSSQLServer. MSSQL did start sucessfully. I found out that an error window appeared when the server was rebooted, however it was ignored by the operator at the time. I have since been informed that the operator during the weekly reboot will verify that SQLServer Agent is back up. Thanks!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •