March 29, 2018 at 11:19 am
Comments posted to this topic are about the item DB Blocking Automated E-mail Alerting with Blocker SP ID & query's
April 5, 2018 at 11:27 am
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.
April 25, 2018 at 12:19 am
Hi chuck.hamilton,
Thanks for your suggestion, It's also a batter way to get the blocking detail. I will try this as well.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy