Page History

...

Anchor
ARActions ARActions

Access the Alert Response window

1. Select Image Removed Image Added > Alert Actions and Responses.  

...

• 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

...

To run a PowerShell script as an alert response: 

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

...

To start a program as an alert response:

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

...

To enable query waits as an alert response:

1. Enable the Query Waits provider and the Query Waits Settings dialog displays.  
2. Select either Enable query waits to enable the query monitor until it is manually disabled or Enable query waits for a limited time and configure the duration.
3. Click OK.

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.

Anchor
servicenow servicenow

ServiceNow Action Provider

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

...