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

I need to setup an alert if SQLAgent is down using a query, I have not bee able to figure it out

I want to use this query

IF EXISTS(SELECT 1 FROM sys.dm_exec_sessions WHERE program_name = 'SQLAgent - Generic Refresher')
    SELECT 'TRUE'
ELSE
    SELECT 'FALSE'

Find more posts tagged with

Accepted answers

All comments

Within which product? More than likely you'll need to convert the output to a number. In Server & Application Monitor (SAM) , there's a SQL Server User Experience Monitor that can run queries and return results. The results need to be numerical though. Easy fix for your query is that 1 = True and 0 = False.

Quick Links