Recently, I was asked if it was possible to cancel a group of running contact processes.
The answer is yes it is. Changing the STATUS in the PROCESS table will allow for this.
Here are the following valid STATUS values:
you have some way of identifying the records you want to end the
process you could write a query like the following (this example will
abort any contacts having a active process with a last name of “Smith”):
process set status=’-101′ where targetid in (select contactid from
contact where lastname=’smith’) and status not in (‘-101′,’-100′)