Sometimes it is useful to find which job is blocking. sp_who2 will show you the running processes, but you will not know which job started the process. Use INPUTBUFFER to narrow this down:
— List running processessp_who2— Enter SPIDDBCC INPUTBUFFER(77)
Find what process the job is waiting on:
SELECT wt.session_id,
ot.task_state,
wt.wait_type,
wt.wait_duration_ms,
wt.blocking_session_id,
wt.resource_description,
es.[host_name],
es.[program_name]
FROM sys.dm_os_waiting_tasks wt
INNER JOIN sys.dm_os_tasks ot ON ot.task_address = wt.waiting_task_address
INNER JOIN sys.dm_exec_sessions es ON es.session_id = wt.session_id
WHERE es.is_user_process = 1
