Job details

• VastSQL

  SSC-Dedicated

  Points: 36067

  More actions

  November 7, 2012 at 8:14 am

  #266603

  Hi Experts,

  How can i find the job name from the program_name value= SQLAgent - TSQL JobStep (Job 0xD498185D4A27E947ABE673A5CD93B09B : Step 1) in sysprocesses .

• Ant-Green

  SSC Guru

  Points: 113445

  More actions

  November 7, 2012 at 8:34 am

  #1556816

  Use the binary hex as the clause for the job_id

  SELECT * FROM msdb.dbo.sysjobs where job_id = 0xD498185D4A27E947ABE673A5CD93B09B

• VastSQL

  SSC-Dedicated

  Points: 36067

  More actions

  November 7, 2012 at 8:57 am

  #1556830

  Thanks Anthony