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 0×1D8274F1H00B7D44912BD78DCADB1AD0 : Step 1)
Use this statement to find out the job name:
select name
from msdb.dbo.sysjobs
where job_id = cast(0×1D8274F1H00B7D44912BD78DCADB1AD0 as uniqueidentifier)
phi.he Said,
April 1, 2008 @
非常感谢您的帖子,为我解决了一个疑难问题.
Haidong Ji Said,
April 1, 2008 @
不客气，很高兴能帮上忙。