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:
-100 is Completed
-101 is Aborted
1 is In Process
2 is Starting
Also, if you want you can also set the SUSPENDED field to 1 to suspend a process and then change it back to 0 to resume it.
If
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”):
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”):
update
process set status=’-101′ where targetid in (select contactid from
contact where lastname=’smith’) and status not in (‘-101′,’-100′)
process set status=’-101′ where targetid in (select contactid from
contact where lastname=’smith’) and status not in (‘-101′,’-100′)
