Home Forums SQL Server 2005 SQL Server 2005 Strategies How to notify through DB MAIL when sql server agent stopped automatically? RE: How to notify through DB MAIL when sql server agent stopped automatically?

  • December 12, 2012 at 2:37 pm

    #1568075

    This is not an explicit answer to your question but it may provide an acceptable work-around if you haven't already implemented it.

    Right-click on "SQL Server Agent" in your SSMS GUI and select "Properties". The "General" tab has settings for SQL Server and SQL Server Agent that will ensure they automatically restart if they inadvertently stop.