The SQL Server Event Type tab of the Edit Event Alert Rule wizard allows you to change the type of SQL Server event on which you want to alert.

Available actions

Select type of event that triggers this alert

Allows you to select the SQL Server event type that triggers this alert. When the Collection Server processes an audited event that matches the specified event type, the alert rule is run to see whether the identified event matches the other alert rule criteria.

You can also select a specific event or a user-defined event. A specific event is any supported SQL Server event that occurs at the server or database level. A user-defined event is a custom event created and tracked using the sp_trace_generateevent stored procedure.

Edit rule details

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

 

SQL Compliance Manager audits all activity on your server. Learn more > >
  • No labels