[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 358
  • Last Modified:

SQL Server alert when agent is not running

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
arthrex
Asked:
arthrex
  • 3
1 Solution
 
RiteshShahCommented:
once your Agent stops working than how could it be able to send you alert?
0
 
RiteshShahCommented:
0
 
ALaRivaCommented:
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
 
RiteshShahCommented:
Microsoft MOM would be good I guess, more you can get idea from the link I provided above
0

Featured Post

Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now