The Alert Actions tab of the New Event Alert Rule wizard allows you to select the action you want this alert rule to perform when an audited event matches the specified criteria. Depending on the actions you select, IDERA SQL Compliance Manager writes an alert message to the application event log and emails it to a specific email address or distribution list. You can use the default alert message or customize it to display the information you need most.  In addition, you can also specify how often to receive email alert notifications with a summarized list of the accumulated alerts that occurred between the selected interval timeframes. 

To successfully use email notification, ensure SQL Compliance Manager is configured to connect to your mail server. For more information, see the Configure Email Settings window.

Available actions

Select alert action

Allows you to select whether you want an alert message to be generated when this alert is triggered. You can configure an alert message to be written to the application event log and emailed to a specific address or distribution list. SQL Compliance Manager uses the same alert message content for the event log entry and email notification. The following are the available alert actions: 

• • Email Notification - Receive an email notification for every event that matches the configured alert rule.
  • Email Summary Notification - Receive an email with a summarized list of the accumulated alerts and limit the number of notifications you get by setting up a time interval to receive email notifications.
  • Event Log Entry - Writes the alert message as an event log entry in the application event log.
  • SNMP Trap - Receive the alert notification as an SNMP Trap
  • Send email summary notification every - Set up a time interval of up to 24 hours to receive email summary notifications.  

Edit rule details

Allows you to specify one or more of the following attributes, depending on the alert action you selected:

• • • Email Notification - Addresses to which the alert message should be emailed.
    • Email Summary Notification - Addresses to which the summarized list of alert messages should be emailed at the previously specified time interval.  
    • Event Log Entry - Type of event log entry that should be written (Warning, Error, Information).
    • SNMP Trap - Content of the alert message.

The rule details pane also allows you to change your specified alert rule criteria at any time as you create your new alert rule. As you specify criteria using the New Event Alert Rule wizard, the rule details grow to include these additional settings. To edit previously set criteria, click the corresponding setting.