Page History

Use the Alert Response window to create or modify your new alert response rule.  

Anchor
ARActions ARActions

Access the Alert Response window

...

Trigger a response only if multiple metrics in the specified list reach the specified threshold(s). Click metric, and then select metrics to include in the alert response trigger. Click Select all to include all of the displayed metrics.

Where metric severity has changed

...

Action providers allow you to select actions that you want to occur as part of the alert response. By default, all actions are disabled. To enable an action, click Enable next to the appropriate action. The following actions help you manage alert response rules:

• Email (SMTP) Provider
• EventLog Action Provider
• Network Management Protocol (SNMP) Trap Message Provider
• PowerShell Action Provider
• Prescriptive Analyzer Action Provider
• Program Action Provider
• Query Monitor Action Provider
• Query Waits Action Provider
• SCOM Alert Action Provider
• SCOM Event Action Provider
• ServiceNow Action Provider
• SQL Agent Job Action Provider
• SQL Script Action Provider

Anchor
emailprovider emailprovider

Email (SMTP) Provider

When the criteria for the new alert rule is met, SQL Diagnostic Manager sends an alert email message to the SMTP server, which then forwards the message to the specified email address. Configure your email settings and network manager settings to receive these alert email messages. 

Anchor
eventlogap eventlogap

EventLog Action Provider

When the criteria for the new alert rule is met, an entry to the EventLog is created.

Anchor
networkprovider networkprovider

Network Management Protocol (SNMP) Trap Message Provider

When the criteria for the new alert rule is met, SQL Diagnostic Manager sends an SNMP Trap message to the network management console based on the configuration of your email settings and network management settings.

Anchor
powershellap powershellap

PowerShell Action Provider

...

1. Enable the PowerShell Action provider and the PowerShell Action dialog displays.  
2. Enter a description for the PowerShell command in the Description field.  
3. Either type in the PowerShell command you want to run when the alert criteria is met, or paste in the PowerShell command from another application.
4. Click Test to verify your PowerShell command.
5. Click OK.

Anchor
prescriptiveprovider prescriptiveprovider

Prescriptive Analyzer Action Provider

When the criteria for the new alert rule is met, it triggers the Prescriptive Analyzer to run a prescriptive analysis on a specific server based on selected performance categories.

...

1. Enable the Prescriptive Analyzer provider and the Prescriptive Analysis Settings window displays.
2. Select the performance categories of your choice.
3. Click OK.

Anchor
programprovider programprovider

Program Action Provider

 When the criteria for the new alert rule is met, you can specify a program for the SQLdm Management Service to run in response to the alert.

...

1. Enable the Program Action provider and the Program Action dialog displays.  
2. Enter a description for the Program action.

3. Enter the full path to the program you want to launch as an alert response. Use the More Options drop-down menu to select from common runtime arguments.

   Tip
   You can run executable (.exe) files only through the Program Action Provider. If you need to run a batch (.bat) file, use cmd /c run.bat.

4. Enter the full path of the directory in which you want the program to run.  

   Tip
   The Start in field is useful when you want a different directory for where an action begins and where the program resides.

5. Click Test to make sure that the SQLdm Management Service can run the program.
6. Click OK.

Anchor
querymonitorap querymonitorap

Query Monitor Action Provider

When the criteria for the new alert rule is met, it triggers the Query Monitor to start so that you can collect more information.

...

Anchor
scomalert scomalert

SCOM Alert Action Provider  

When the criteria for the new alert rule is met, SQL Diagnostic Manager sends an alert to SCOM.  

To create SCOM alert response:  

1. Send to SCOM as Alert option.
2. Select the metrics you want to be sent to SCOM as alerts. You can also select all available metrics.
3. Click OK.

...

To create SCOM alert response:  

1. Send to SCOM as Event option.
2. Select the metrics you want to be sent to SCOM as alerts. You can also select all available metrics.
3. Click OK.

...

When the criteria for the new alert rule is met, SQL Diagnostic Manager sends an alert to ServiceNow.

To enable ServiceNow as an alert response:

1. Enable Send ServiceNow as Alert option.
2. Provide the following information regarding the ServiceNow configuration:
   1. Provider Name. By default, ServicerNow Action Provider
   2. URL.
   3. User Information
      • Username.
      • Password.
      • Alert Source. By default, SQL Diagnostic Manager.
3. Click OK.

Anchor
sqlagentjob sqlagentjob

SQL Agent Job Action Provider

When the criteria for the new alert rule is met, you can specify a SQL Agent Job to run in response to the alert.

To start a SQL Agent Job as an alert response:

1. Enable the SQL Agent Job Action provider and the SQL Agent Job Action dialog displays.  
2. Select the SQL Server instance from the Server drop-down list or select %(Instance) to run the SQL Agent Job on the server that caused the alert.
3. Click Browse next to the Job Name field.
4. On the Select Job window, select the SQL Server instance the SQL Agent Job is located on and click Load.
5. Select the SQL Agent job from the list and click OK.
6. If you want to select a particular Job Step to run, click the Browse button in the Job Step window
   
   1. In the Select Job Step window click Load.
   2. Select the Job step from the list and click OK.
   3. Click Test to verify your configuration.
   4. Click OK.

Anchor
sqlscriptprovider sqlscriptprovider

SQL Script Action Provider  

When the criteria for the new alert rule is met, you can specify a SQL Server script to run in response to the alert.

...

1. Enable the SQL Script Action provider and the SQL Script Action dialog displays.  
2. Enter a description for the SQL Script Action in the Description field.
3. Click Browse to select the SQL Server instance or leave it at the default of %(Instance) to run the SQL Script on the server that caused the alert.
4. Either type in the T-SQL you want to run when the alert criteria is met, or paste in the T-SQL from another application.
5. Click Test to verify your SQL script.
6. Click OK.

Change the condition value

You can edit the rule description by clicking the underlined value from the Step 3 section. SQL Diagnostic Manager displays a list of currently defined items for you to select as the new value. Make the necessary updates, and then click OK.

Image Modified