手动清理审批流

DECLARE @deleteBefore DATETIME;

SET @deleteBefore = ‘2017-1-1’;

–工作流日志，这个表有可能很大，记录了工作流计算的过程，如果工作流没出错的话其实没啥用，直接清空即可

[wppay]

DELETE FROM WF_CurrentLog
WHERE CreateTime < @deleteBefore;

–流程实例锁定表
DELETE FROM WF_PILock
WHERE PIID IN ( SELECT PIID
FROM WF_ActiveFlow
WHERE StartTime < @deleteBefore );

–历史状态表
DELETE FROM WF_FlowState
WHERE PIID IN ( SELECT PIID
FROM WF_ActiveFlow
WHERE StartTime < @deleteBefore );

–工作流任务逻辑关系
DELETE FROM Table_Task_Relation
WHERE cTK_ID IN ( SELECT cTK_ID
FROM Table_Task
WHERE cCreateTime < @deleteBefore );

–工作流任务表
DELETE FROM Table_Task
WHERE cCreateTime < @deleteBefore;

–流程实例表
DELETE FROM WF_ActiveFlow
WHERE StartTime < @deleteBefore;

[/wppay]