DB Blocking Automated E-mail Alerting with Blocker SP ID & query's

Question

Viewing 3 posts - 1 through 2 (of 2 total)

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

chuck.hamilton SSCommitted Points: 1539 More actions · Answer 1

Rather than run the job every 2 minutes why not use SQL Server Agent to run the job when it detects a blocked session?

1) Set server "blocked process threshold (s)" to the number of seconds after which you want the alert fired
2) Create an alert in the agent

3) On the "response" tab, execute your job.(or any job that queries who's blocking who) and email it to yourself.

Subhash Chandra Say Hey Kid Points: 692 More actions · Answer 2

Thanks for your suggestion, It's also a batter way to get the blocking detail. I will try this as well.