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.

1System Event
9Collect SQM data
10*Workflow Operation
12Update Match Code
25Generate Full Text Catalog
27Update 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 
2Locked20In Progress
0Ready0Waiting for Resources

Automatic deletion of entries from this table can be enabled if Update Rollup 3 is installed. Refer to: for removing workflow expansion tasks for removing completed workflow entries

This article describes how to manually remove entries from the asyncoperationbase table.

Leave a Comment

Your email address will not be published. Required fields are marked *