Identifying SQL Agent Job from the format - SQLAgent - TSQL JobStep (Job 0xC4A075BBC7D7FB4993E60371

This article helps you get the SQL Server agent job name from the hexadecimal Job ID format.

Let’s say you have deadlock information that shows the following data for the “client app” attribute:

clientapp=SQLAgent – TSQL JobStep (Job 0xC4A075BBC7D7FB4993E603719D4EDDE5: Step 1)

Based on this output, we know a SQL Server Agent Job is involved, but what is the SQL Server Agent Job name? Run the following query and specify the string in the where clause.

select job_id, name, description
from msdb..sysjobs 
where 
 CONVERT(binary(16), job_id) = 0xC4A075BBC7D7FB4993E603719D4EDDE5