Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials
Store

Crear alerta cuando se caiga el agente

rodrigo.araya.82

Estimados, es posible crear una alerta que informe cuando se caiga el agente de SQL Server?
Tengo el DPA 12.0.3074.

Gracias. de antemano

Find more posts tagged with

dpa 12.0.3074

Accepted answers

Here is another option that is more generic and does not use XP_servicecontrol: Monitor SQL Server Agent - No XP Proc

All comments

DPA can monitor the SQL Agent via an alert type named "Windows Service Not Running". To create that alert, click on Alerts and then the Manage Alerts tab:

On the next page, fill out the alert name, frequency, select instances to execute against and for the Service Name field use the name from the Windows Service screen. In my case, I have a SQL2014 named instance so I enter SQLAgent$SQL2014.

There is also a custom alert example here: SQL Server SQL Agent Alert - Monitor SQL Agent

Here is another option that is more generic and does not use XP_servicecontrol: Monitor SQL Server Agent - No XP Proc

Quick Links