Chat now with support
Chat with Support

Spotlight on SQL Server Enterprise 11.7 - Release Notes

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.

TIP: When you use The connection is... condition there are some things to be aware of. For more information, see The Connection is….

 

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

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating