InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comMon, 20 May 2013 11:46:30 GMT20http://www.sqlservercentral.com/Forums/Topic1382010-1550-1.aspxThanks AnthonyWed, 07 Nov 2012 08:57:09 GMTRatheesh.K.Nairhttp://www.sqlservercentral.com/Forums/Topic1382010-1550-1.aspxUse the binary hex as the clause for the job_idSELECT * FROM msdb.dbo.sysjobs where job_id = 0xD498185D4A27E947ABE673A5CD93B09BWed, 07 Nov 2012 08:34:53 GMTanthony.greenhttp://www.sqlservercentral.com/Forums/Topic1382010-1550-1.aspxHi Experts,How can i find the job name from the program_name value= SQLAgent - TSQL JobStep (Job 0xD498185D4A27E947ABE673A5CD93B09B : Step 1) in sysprocesses .Wed, 07 Nov 2012 08:14:34 GMTRatheesh.K.Nair