Based on the criteria defined in your alert rules, SQL Compliance Manager will write a custom alert message to the application event log or email a custom alert message to the specified addresses when an alert is triggered. You can change which action SQL CM takes when the event or Status Alert is triggered.
If you want to receive alert email notifications, ensure you have configured SQL Compliance Manager to connect to your SMTP server. For more information, see Receive alerts through email.
To change the action an alert performs:
- Select Alert Rules in the Administration tree.
- Right-click the rule for the event or Status Alert you want to change, and then select Properties on the context menu.
- Click Next to navigate to the Alert Actions window.
- Select the action you want SQL Compliance Manager to take when this alert triggers. To configure the email notification message or event log entry, use the links provided on the rule details pane.
- Click Finish.