Find out which Sql Server Agent job it is running

In Activity Monitor (Sql Server 2005) or Current Activities (Sql Server 2000), if you suspect a job has been running unusually long, all you see is something like this:

SQLAgent – TSQL JobStep (Job 0x1D8274F1H00B7D44912BD78DCADB1AD0 : Step 1)

Use this statement to find out the job name:

select name
from msdb.dbo.sysjobs
where job_id = cast(0x1D8274F1H00B7D44912BD78DCADB1AD0 as uniqueidentifier)

2 thoughts on “Find out which Sql Server Agent job it is running”

  1. 非常感谢您的帖子,为我解决了一个疑难问题.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.