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

How to create an alert for SQL failed jobs

mafaaz93 · 2021-09-30T14:26:36+00:00

* Open the Orion Web Console. * Click Settings > Manage Alerts. * Click Add New Alert * Go to the Trigger Actions page. * Add an Action, for example, "Send an Email/Page". * In the Subject/Message. the variable "${N=SwisEntity;M=SqlJobInfoAlert.Name}" will give the name of the job which triggered the Alert. * Save the…

mafaaz93

Open the Orion Web Console.
Click Settings > Manage Alerts.
Click Add New Alert
Go to the Trigger Actions page.
Add an Action, for example, "Send an Email/Page".
In the Subject/Message. the variable "${N=SwisEntity;M=SqlJobInfoAlert.Name}" will give the name of the job which triggered the Alert.
Save the configuration of the alert.

Find more posts tagged with

Alert

sql alerts

Comments

idrockman

This is all good, but what conditions do you set?

I currently have: AppInsight for SQL: Job Info --> Job Status (SQL Job Info Alerting Properties), but I do not know what to set the constraint to ?

Please help...

Note: I found the solution here: AppInsight for SQL - Create an alert for SQL failed jobs (solarwinds.com)

Quick Links

Cisco ASR Devices
Cisco ASR Devices.pollerCisco ASR Devices
Basic SWQL Syntax
SWQL is built on the framework of SQL and as such supports most of the standard clauses as part of a query. A very simple example query is: SELECT Caption, IPAddress, Vendor, ResponseTime FROM Orion.Nodes Dissecting this query is relatively straightforward: show some fields (Caption, IP address, Vendor, and Response Time)…
Cisco ASA SSL Tunnels
Active SSL Tunnels-ASA.UnDPThis poller *should* display the number of Active SSL VPN (Anyconnect) Tunnels currently connected to your box. However, I tried it with my 5520 running 8.0.4 and for some reason I get a OID Not Supported. Here's my post in the forum: *EDIT* This is confirmed working with at least Interm release…
HP ProCurve Switches Hardening check
HP ProCurve Switches Hardening check.xmlGeneral hardening for HP switches