update VS4TJobMB set TJbMProcessStatus=4 WHERE TJbMProcessStatus=5 and TJbMFinishQT>0
GO
update VS4TJobMethod set TJstProcessStatus=4 WHERE TJstProcessStatus=5 and TJStFinishQT>0
GO
update VS4TJobMB set TJbMProcessStatus=6 WHERE TJbMProcessStatus=4 and TJbMFinishPC>=100
GO
update VS4TJobMethod set TJstProcessStatus=6 WHERE TJstProcessStatus=4 and TJStFinishPC>=100
GO