The SQL Server Object type tab of the Edit Event Alert Rule wizard allows you to change the type of SQL Server object that should be monitored by this alert rule. You can generate alerts for objects on currently audited databases and SQL Server instances.

Available actions

Select the object that triggers this alert

Allows you to specify the SQL Server object type that should trigger this alert. When the Collection Server processes an audited event associated with the specified object type, the alert rule is run to see whether the identified event matches the other alert rule criteria.

By default, the alert rule will generate alerts for matching events on all audited SQL Server instances.

You can specify one or more objects:

Type of ObjectYou can specify ...
SQL Server instance
  • Any instance
  • A specific instance by name
  • A specific database by name
  • Any database whose name matches a naming convention or phrase
Database object
  • A specific database object by name
  • Any database object whose name matches a naming convention or phrase
Host Name
  • Any host name
  • A specific host name

For example, you can specify the following objects:

      • Any database whose name contains the word test on the LABSERVER instance
      • The model database on any audited instance
      • The Salary table in the HR01 database hosted by the Chicago instance 

Edit rule details

Allows you specify the word or phrase the alert rule should use to identify events associated with the object you want to alert on.

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.

IDERA | Products | Purchase | Support | Community | Resources | About Us | Legal
  • No labels