top of page

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

Updated: Dec 31, 2021

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




2,327 views0 comments

Recent Posts

See All

Comments


bottom of page