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 responses to “Find out which Sql Server Agent job it is running”
非常感谢您的帖子,为我解决了一个疑难问题.
不客气，很高兴能帮上忙。