SQl JOB [英] SQl JOB
本文介绍了SQl JOB的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
大家好,
我在Prod中有一个SQL作业,它运行了6天,我的存储过程有2100个声明我不知道当前正在运行哪个语句。
任何人都知道如何查看当前的工作陈述。
谢谢
解决方案
SELECT session_Id
,DB_NAME( sp.dbid)database_name
,nt_username
,er.status
,wait_type
,qt.text
,program_name
,主机名
, nt_domain
,start_time
FROM sys.dm_exec_requests er
INNER JOIN sys.sysprocesses sp ON er.session_id = sp.spid
CROSS APPLY sys.dm_exec_sql_text(er.sql_handle)as qt
WHERE session_Id> 50
AND sp.program_name LIKE'SQLAgent - TSQL JobStep(作业%'
AND session_Id NOT IN(@@ SPID);
Hi All,
I have a sql Job in Prod which is running past 6 days and my stored proc having 2100 statement I have no idea which statement is running currently.
Can anyone knows how can I check the current statement of my job.
Thanks
解决方案
SELECT session_Id ,DB_NAME(sp.dbid) database_name ,nt_username ,er.status ,wait_type ,qt.text ,program_name , Hostname , nt_domain , start_time FROM sys.dm_exec_requests er INNER JOIN sys.sysprocesses sp ON er.session_id = sp.spid CROSS APPLY sys.dm_exec_sql_text(er.sql_handle)as qt WHERE session_Id > 50 AND sp.program_name LIKE 'SQLAgent - TSQL JobStep (Job %' AND session_Id NOT IN (@@SPID);
这篇关于SQl JOB的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文