Applications Systems

AppInsight for SQL - Create an alert for SQL failed jobs

This article describes how to configure an alert for SQL Jobs with AppInsight for SQL.

First published date

11/29/2018 10:53 PM

Last published date

6/25/2020 9:30 PM

Overview

This article outlines how to create an alert on SQL failed jobs.

Product section

Server Application Monitor

Resolution

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