Added job names:
...
),'') AS BlockingText
,CASE
WHEN LEFT(es.program_name, 31) = 'SQLAgent - TSQL JobStep (Job 0x' THEN 'SQLAgent - ' + sysjobs.[name]
ELSE Coalesce(es.program_name,' - ')
END as ProgramName
,Coalesce(es.client_interface_name,' - ') as ClientInterface
...
On ec.session_id = st.session_id
LEFT JOIN
[msdb].[dbo].[sysjobs] sysjobs
WITH (NOLOCK)
ON
CONVERT(VARCHAR(50), sysjobs.[job_id])
= SUBSTRING(es.program_name, 38, 2)
+ SUBSTRING(es.program_name, 36, 2)
+ SUBSTRING(es.program_name, 34, 2)
+ SUBSTRING(es.program_name, 32, 2)
+ '-'
+ SUBSTRING(es.program_name, 42, 2)
+ SUBSTRING(es.program_name, 40, 2)
+ '-'
+ SUBSTRING(es.program_name, 46, 2)
+ SUBSTRING(es.program_name, 44, 2)
+ '-'
+ SUBSTRING(es.program_name, 48, 4)
+ '-'
+ SUBSTRING(es.program_name, 52, 12)
Where es.is_user_process >= (case when @IsUserProcess = 0 Then 0 Else 1 End)
...