Detect head blocker and how to retrieve job step name or job name for a SQL server Agent job. What will you do if you get blocking sessions:- using below script check head blocker --------------------------------------------------- SET NOCOUN…