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

SQL Scripts and Alert based on result string

We have jobs created in SQL Agent and we want to create the replica in Solarwinds. Few of our jobs return the result that are not numeric and we want to create a monitor that returns different strings and alert is generated with the strings that are returned. How can we do that or which variable in the alert fetches the procedure/query results?

Find more posts tagged with

Accepted answers

All comments

aLTeReGo

The SQL user experience monitor requires that a single numerical statistic is returned as part of the query. You can also include an optional message which is usually used for returning the column or row name.

The template below should help get you started monitoring your SQL Agent jobs.