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 8:20 am

    #1567911

    Chris Harshman (12/12/2012)

    The problem is that SQL Agent is the program you'd typically use to do monitoring and alerting. It sounds like what you really need is some kind of watchdog program that ensures Windows services are running on your servers.

    Another option might also be able to setup some script or something to run when the service fails. In the Control Panel \ Administrative Tools \ Services, right click on the service, and select the Recovery tab. You can specify here what happens when the service fails.

    yep I', with Chris;

    this is the "how can i make the watchman notifyme if the watchman dies?"

    you can't, you have to use a different tool, something that the item you ar emonitoring does not depend on or use.

    if you search for SQL monitoring software or network monitoring software, you'll find a lot of items;

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!