Spotlight on SQL Server Enterprise 11.7 - Management Pack for SCOM User Guide

Run a program

The standard scenario may be:

• for a given connection
• when a specific alarm is raised
• of specific severity (severities)
• run a program

How can this rule be created and maintained in the Alarm Action Editor?

Creating the rule

1. Click Configure | Alarm Actions.

   

2. Click New to create a new rule.
3. If this rule is related to specific connections
   1. In the list of conditions, tick The connection is...
   2. In the rule description click connections. Select the connections this rule applies to.
4. If this rule is related to specific alarms
   1. In the list of conditions, tick The alarm is...
   2. In the rule description click alarms. Select the alarms this rule applies to.
5. If this rule is related to specific severities
   1. In the list of conditions, tick The alarm severity is...
   2. In the rule description click Low, Medium or High. Select the severities this rule applies to.
6. In the list of actions to perform, tick Run a program
   1. In the rule description, click (program). This opens the Run a Program Dialog.

Variable conditions - multiple rules

For any given rule, all the actions are taken when all the conditions are met. Any variability requires separate rules.

Following is an example.

For all alarms
where the connection type is one of os/vmware, os/windows
      and the alarm severity is High
   run programA

For all alarms
where the connection type is database/sqlserver
      and the alarm severity is Medium or High
   run programB