Page History

...

Anchor
ARActions ARActions

Access the Alert Response window

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

...

Trigger a response when the listed SQL Server instance is included in the displayed list. Click specified list, and  and then select one or more instances to include in the alert response trigger. Click Select all to include all of the displayed instances.

...

Trigger a response if the metric is included in the displayed list. Click metric, and  and then select one or more metrics to include in the alert response trigger. Click Select all to include all of the displayed metrics.

...

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

...

Trigger a response when the metric severity changes regardless of level. Click the displayed severity level , and then select one or more severity levels to include in the alert response trigger.

...

Trigger a response if the refresh occurred during the displayed time frame. Click during this time, and  and then select the time and date range to set the alert response trigger time frame.

...

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 click Enable next to the appropriate action. The following actions help you manage alert response rules:

...

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.

...

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.

...