Chat now with support
Chat with Support

Spotlight on SQL Server Enterprise 11.7 - Release Notes

Send email to...

The standard scenario may be:

  • for a given connection
  • when a specific alarm is raised
  • of specific severity (severities)
  • send an email

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 Send email to...
    1. In the rule description, click (recipient). This opens the Send an Email 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.

You may want to direct operating system related alarms to the help desk and SQL Server related alarms to the DBA group.

For all alarms
where the connection type is one of os/vmware, os/windows
   send email to helpdesk@company com

For all alarms
where the connection type is database/sqlserver
   send email to dbagroup@company com

The severity may determine the action.

For all alarms
where the connection type is one of os/vmware, os/windows
      and the alarm severity is High
   send email to helpdesk@company com

For all alarms
where the connection type is database/sqlserver
      and the alarm severity is Medium or High
   send email to dbagroup@company com

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating