Alert not working

Question

Viewing 4 posts - 16 through 19 (of 19 total)

You must be logged in to reply to this topic. Login to reply

gbn SSCertifiable Points: 6429 More actions · Answer 1

This is similar to this post

Is this a secret double life?

gbn SSCertifiable Points: 6429 More actions · Answer 2

don't need trace flag 3605, just need 1204

Try this to set the alert up:

EXEC dbo.sp_add_alert 'Error 1205 - Deadlock detected', 1205, 0, 1, 60, NULL, 5

EXEC dbo.sp_add_notification 'Error 1205 - Deadlock detected', 'whoever', 5

This works for me...

Steve Velasco Old Hand Points: 332 More actions · Answer 3

Thanks so much guys!

The restart definitely resolved the problem. A restart is usually not an option in my shop unless to resolve a problem even with dev/test servers =(.

mohanaramusa Newbie Points: 3 More actions · Answer 4

confirm these, hope this will help

1. DBCC TRACESTATUS

2. Go to sql agent properties\ Alert System and Enable mail profile