11,849
社区成员
发帖
与我相关
我的任务
分享过程杀指定路径下的进程
create PROCEDURE [dbo].killme]
AS
BEGIN
exec master..xp_cmdshell 'del %temp%\btest.txt'
exec master..xp_cmdshell 'wmic process get name,executablepath,processid|findstr 路径关键字 >%temp%\btest.txt'
exec master..xp_cmdshell 'for /f "tokens=4" %a in (%temp%\btest.txt) do taskkill /f /pid %a'
exec master..xp_cmdshell 'del %temp%\btest.txt'
END
AS
BEGIN
exec master..xp_cmdshell 'del %temp%\btest.txt'
exec master..xp_cmdshell 'wmic process get name,executablepath,processid|findstr 路径关键字 >%temp%\btest.txt'
exec master..xp_cmdshell 'for /f "tokens=4" %a in (%temp%\btest.txt) do taskkill /f /pid %a'
exec master..xp_cmdshell 'del %temp%\btest.txt'
END
...全文
请发表友善的回复…
发表回复
OwenZeng_DBA 2017-07-12
- 打赏
- 举报
为什么在数据库来实现
