循环杀进程

循环杀进程

DECLARE @SPID AS INT
DECLARE @COUNT AS INT=0
 
DECLARE curSPID CURSOR FOR
SELECT SPID
FROM master..sysprocesses  
-----添加要杀进程的条件
WHERE   spid>50  and status='SLEEPING' and dbid=DB_ID('AdventureWorks2016')

 
OPEN curSPID
FETCH NEXT FROM curSPID INTO @SPID
 
WHILE @@FETCH_STATUS = 0
BEGIN
    EXEC('KILL '+ @SPID)
    SET @COUNT+=1
    PRINT 'KILL '+ CAST(@SPID AS VARCHAR)
    FETCH NEXT FROM curSPID INTO @SPID
END
PRINT 'KILL COUNT：'+ CAST(@COUNT AS VARCHAR)
CLOSE curSPID
DEALLOCATE curSPID

 

posted @ 2019-02-28 14:33 JinweiChang 阅读( ...) 评论( ...) 编辑 收藏

转载于:https://www.cnblogs.com/JinweiChang/p/10461756.html