Setup a simple alert with SQL agent

When I test the alert it does not trigger the alert

Since error is not being logged, we can verify in the sys.messages

Lets alter the message to log

SELECT * FROM sys.messages WHERE
language_id = 1033 AND severity = 16
and message_id = 2812
EXEC sp_altermessage @message_id = 2812, @parameter = ‘WITH_LOG’ ,@parameter_value = ‘True’

Test the alert again, now we can see number of occurrences increases to 1