Asyncoperationbase table - operationtype, status code and state code

The asyncoperationbase table stores details of system jobs (including workflows). The following table details some of the different job types that are stored in the table.

operationtype	Description
1	System Event
9	Collect SQM data
10*	Workflow Operation
12	Update Match Code
25	Generate Full Text Catalog
27	Update Contract States

Note: For entries where the operationtype is 10, there are also related entries in the workflowlogbase table (join on the asyncoperationid field). The CRM SDK lists additional operationtypes.

State Code		Status Code
3	Completed	30	Succeded
		31	Failed
		32	Canceled
2	Locked	20	In Progress
		21	Pausing
		22	Canceling
1	Suspended	10	Waiting
0	Ready	0	Waiting for Resources

Automatic deletion of entries from this table can be enabled if Update Rollup 3 is installed. Refer to:

• http://support.microsoft.com/kb/957871/ for removing workflow expansion tasks

• http://support.microsoft.com/kb/968755/ for removing completed workflow entries

This article http://support.microsoft.com/kb/968520 describes how to manually remove entries from the asyncoperationbase table.