Solved

SQL Server alert when agent is not running

Posted on 2009-05-05
4
349 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
4 Comments
 
LVL 31

Expert Comment

by:RiteshShah
ID: 24305537
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
ID: 24305619
0
 
LVL 10

Expert Comment

by:ALaRiva
ID: 24305642
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
ID: 24305667
Microsoft MOM would be good I guess, more you can get idea from the link I provided above
0

Featured Post

Edgartown IT Case Study

Learn about Edgartown's quest to ensure the safety and security of the entire town's employee and citizen data. Read the case study!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

There are some very powerful Data Management Views (DMV's) introduced with SQL 2005. The two in particular that we are going to discuss are sys.dm_db_index_usage_stats and sys.dm_db_index_operational_stats.   Recently, I was involved in a discu…
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…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

738 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