Creating an Event Alert rule allows you to begin generating alerts on audit data across your SQL Server environment. To successfully generate an alert, the alert rule criteria you select must match SQL Server event data you are currently auditing on the specified instance or database. For more information, see Use Event Alerts to analyze audit data.
To create an Event Alert:
- Select Alert Rules in the Administration tree.
- Click Event on the New Rule ribbon.
- Select the type of event (event category) that you want to alert on, and then click Next.
- Select the type of object you want to alert on for the selected event type, and then click Next. By default, the alert rule will generate an alert when the selected event occurs on any registered SQL Server instance, database, or database object. Use the links provided on the rule details pane to narrow your alert rule to specific objects or objects that match a naming convention.
- Define the criteria under which the alert should trigger, and then click Next. Use the criteria to narrow your alert rule to generate alerts only under specific conditions. To specify values that the event should match, use the links provided on the rule details pane.
- Select the action you want SQL compliance manager to take when this alert triggers, and then click Next. To configure the email notification message or event log entry, use the links provided on the rule details pane.
- Specify a name and appropriate alert level for this alert, review the summary, and then click Finish. By default, the new alert rule is enabled.