I created a deadlock alert including notification to an operator like this:
EXEC msdb.dbo.sp_add_alert @name=N'1205 Deadlock', @message_id=1205, @severity=0, @enabled=1, @delay_between_responses=30, @include_event_description_in=1, @database_name=N'myDB', @category_name=N'[Uncategorized]', @job_id=N'00000000-0000-0000-0000-000000000000';
This alert is registered for notification.
It's history says it never appeared although it is in place for months and there are multiple deadlocks per day. I created a deadlock manually. It shows up in the Log File.
What is missing for this alert to raise a notification? Other notifications like e.g. 18456 Invalid Login work fine.