sp_GenOverrideHealthAlert
Command - Configuration
Generate code to manage health event overrides.
This code is used to create/remove rules to customize what Health events dbOmnibus alerts on.
The override rules do not prevent dbOmnibus from capturing the health metrics, 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_GenOverrideHealthAlert
Copy the code from the Add Code or Delete Code columns, edit the parameters (if needed) execute to the code.
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.).
Related:
Use sp_ShowOverrides to list the Event and Health overrides for the SQL instance.
Use sp_GenOverrideEventAlert to manage Event Alerts.
The generated code calls [Util].[sp_UpdateOverrides] procedure with the necessary parameters.
Page Last Updated: 21 September 2025