akshay1974 (6/13/2008)

---

The hex is the job_id for the job. You can query sysjobs and it will give you the name of the job.

e.g.
select * from msdb..sysjobs
where job_id = 0x1292021D3C929A4CBBE3895A61FA68CC

Adam Bean (6/13/2008)

---

Negative, the program_name from sysprocesses does not match up to the job_id from sysjobs.

For example, I'm showing SQLAgent - TSQL JobStep (Job 0x3E31DB24ED72CD49A8114462A66A0367 : Step 1) in sysprocesses, yet the job_id for this job is 24DB313E-72ED-49CD-A811-4462A66A0367.

select j.name 
from msdb.dbo.sysjobs j 
     inner join 
     msdb.dbo.sysjobsteps s on j.job_id = s.job_id 
where step_uid = '3E31DB24ED72CD49A8114462A66A0367'  --job step id

For example, I'm showing SQLAgent - TSQL JobStep (Job 0x3E31DB24ED72CD49A8114462A66A0367 : Step 1) in sysprocesses, yet the job_id for this job is 24DB313E-72ED-49CD-A811-4462A66A0367.

akshay1974 (6/13/2008)

---

The hex is the job_id. Try the below

select * from msdb..sysjobs where job_id =
0x3E31DB24ED72CD49A8114462A66A0367