Symptoms

How to remove workflow tasks from the database using SQL
 

Diagnoses

Is it possible to remove many tasks for a specific store (e.g. today it is over 50). Is there a way to remove this from the database using SQL or some other way besides going and removing 1 by 1 from the web application front end?


 

Resolution

Yes this possible upon K2 Underground site there is a script that allows you to this. This is actually a stored procedure. It is recommended that you back up your database before applying this within the DB.

You can access the link directly below:

http://old.k2underground.com/blogs/johnny/archive/2008/04/15/deleting-obsolete-process-instances-from-a-k2-net-2003-or-k2-blackpearl-database.aspx