22,206
社区成员
发帖
与我相关
我的任务
分享
DECLARE @job varchar(100), @jobID varchar(100)
select @job = 'SQLAgent - TSQL JobStep (Job 0xB2525BC0DBA1E844B582EFB55131EACF : Step 1)'
set @job = replace(@job, '(Job 0x', '(0x')
set @jobID = replace(@job, 'SQLAgent - TSQL JobStep (', '')
if (select charindex(' ', @jobID, 1)) > 0
begin
set @jobID = substring(@jobID, 1, charindex(' ', @jobID, 1)-1)
end
select replace(@job, @jobID,
(
select distinct name
from msdb.dbo.sysjobs
where master.dbo.fn_varbintohexstr(job_id) = @jobID
)
)
SELECT * FROM msdb.dbo.sysjobs
SELECT * FROM msdb.dbo.sysjobsteps
-- 看看跑的是什么语句
dbcc inputbuffer(spid)