Snapin Task continuously restarting

[sborgne]

Hi,

I scheduled a Snapin Task (powershell script auditing #6006 windows event) against a group of 134 hosts.
Execution duration is about 10 seconds but, task continuously restart.

Database shows 212256 pending tasks. GUI is down…

How do i clean things ?

Thanks for advices…

[Tom Elliott]

@sborgne I’d start by cancelling all existing tasks:

UPDATE tasks SET taskStateID='5' WHERE taskStateID IN ('0','1','2','3') AND taskTypeID IN ('12','13');