sp_GenOverrideEventAlert
Command - Configuration
Generate code to manage event alert overrides.
This code is used to create/remove rules to customize what Events dbOmnibus alerts on.
The override rules do not prevent dbOmnibus from capturing the events, it prevents the alerts from triggering an email.
If other active alerts trigger an email, then the overrides will be lists at the bottom of the email as a reminder that they are overridden.
This procedure will generate Add Code rows for alerts that have fired.
It will also generate Delete Code for previously created overrides.
Usage:
sp_GenOverrideEventAlert
Copy the code from the Add Code or Delete Code columns, edit the parameters (if needed) execute to the code.
sp_GenOverrideEventAlert 3007
Notes:
If the @Item parameter in the copied code is omitted, dbOmnibus will assume that it is intended to override all Items (i.e., databases or drive letters etc.). This is equivalent to disabling the feature.
Related:
Use sp_ShowOverrides to list the Event and Health overrides for the SQL instance.
Use sp_GenOverrideHealthAlert to manage Health Alerts.
The generated code calls [Util].[sp_UpdateOverrides] procedure with the necessary parameters.
Page Last Updated: 21 September 2025