Solved

SQL Server alert when agent is not running

Posted on 2009-05-05
4
347 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
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

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SQL Where not exists in same table 3 67
SSRS report parameters set after publishing to report manager 1 55
Pivot Query Problem 9 41
SQL Query with Sum and Detail rows 2 49
I've encountered valid database schemas that do not have a primary key.  For example, I use LogParser from Microsoft to push IIS logs into a SQL database table for processing and analysis.  However, occasionally due to user error or a scheduled task…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

776 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