Solved

SQL Server alert when agent is not running

Posted on 2009-05-05
4
345 Views
Last Modified: 2012-05-06
Hi experts,

I had the problem that the sql agent on my sql server wasn't running. Luckily it was just a test server but it made me aware how important it is to receive a notification when the agent stopps running for some reason.
I've had a look at the "Alert" options in the sql server management studio. But I couldn't get it to work. Can someone help me out?

Thanks
0
Comment
Question by:arthrex
  • 3
4 Comments
 
LVL 31

Expert Comment

by:RiteshShah
Comment Utility
once your Agent stops working than how could it be able to send you alert?
0
 
LVL 31

Accepted Solution

by:
RiteshShah earned 500 total points
Comment Utility
0
 
LVL 10

Expert Comment

by:ALaRiva
Comment Utility
You'll need to go with a Third Party Monitoring Tool.  I don't have any specific recommendations as this has not been a concern for me.

Best of Luck,
Anthony
0
 
LVL 31

Expert Comment

by:RiteshShah
Comment Utility
Microsoft MOM would be good I guess, more you can get idea from the link I provided above
0

Featured Post

Free Gift Card with Acronis Backup Purchase!

Backup any data in any location: local and remote systems, physical and virtual servers, private and public clouds, Macs and PCs, tablets and mobile devices, & more! For limited time only, buy any Acronis backup products and get a FREE Amazon/Best Buy gift card worth up to $200!

Join & Write a Comment

Introduction This article will provide a solution for an error that might occur installing a new SQL 2005 64-bit cluster. This article will assume that you are fully prepared to complete the installation and describes the error as it occurred durin…
When writing XML code a very difficult part is when we like to remove all the elements or attributes from the XML that have no data. I would like to share a set of recursive MSSQL stored procedures that I have made to remove those elements from …
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

772 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now