I have performance condition alerts successfully being sent via email however I would like certain alerts to log in the Windows Event Log.
I have tried using 'sp_update_alert' to set @severity=19 but I receive and error from sp_verify_alert
'Msg 14500, Level 16, State 1, Procedure sp_verify_alert, Line 67
Supply either a non-zero message ID, non-zero severity, non-null performance condition, or non-null WMI namespace and query.'
Below is one of the alerts that I would like to send to event logs
EXEC msdb.dbo.sp_add_alert @name=N'TransLog:LogGrowing',
@notification_message=N'Proactive Alert: DB Transaction log size growing too large',
@performance_condition=N'Databases|Log File(s) Size (KB)|P21|>|20000',