The AsyncOperationBase Table: What are all those records anyway?

There have been several KB articles and updates published to help control the size of the AsyncOperationBase table, which can cause your CRM database to grow very large, very quickly. (See here and here.) But just what are all those records anyway?

I pulled the following lists together from the SDK and technet in order to put this info in one place, where it’s a little more user-friendly (at least for me!).

First, the list of AsyncOperationTypes:

Value	Field	Description
1	Event	Specifies a system event.
2	BulkEmail	Specifies a bulk e-mail operation.
3	Parse	Specifies an import file parse operation.
4	Transform	Specifies an operation to transform parse data.
5	Import	Specifies an import operation.
6	ActivityPropagation	Specifies a campaign activity propagation operation.
7	PublishDuplicateRule	Specifies an operation to publish a duplicate detection rule.
8	BulkDetectDuplicates	Specifies a bulk duplicate detection operation.
9	CollectSqmData	Specifies an operation to collect SQM data.
10	Workflow	Specifies a workflow operation.
11	QuickCampaign	Specifies a quick campaign operation.
12	PersistMatchCode	Specifies an operation to update the matchcode.
13	BulkDelete	Specifies a bulk delete operation.
14	DeletionService	Specifies a Deletion Service operation.
15	IndexManagement	Specifies an index management operation.
16	CollectOrgStats	Specifies an operation to collect an organization's statistics.
17	ImportingFile	Specifies an import subprocess operation.
18	CalculateOrgStorageSize	Specifies an operation to calculate an organization's storage size.
19	CollectOrgDBStats	Specifies an operation to collect an organization's database statistics.
20	CollectOrgSizeStats	Specifies an operation to collection an organization's size statistics.
21	DatabaseTuning	Specifies an operation for database tuning.
22	CalculateOrgMaxStorageSize	Specifies an operation to calculate an organization's maximum storage size.
23	BulkDeleteChild	Specifies a bulk delete subprocess operation.
24	UpdateStatisticIntervals	Specifies an operation to update statistic intervals.
25	FullTextCatalogIndex	Specifies an operation to generate an organization full text catalog index.
26	DatabaseLogBackup
27	UpdateContractStates	Specifies an operation to update contract states.
28	ShrinkDatabase
29	ShrinkLogFile
30	ReindexAll	Specifies an index management operation.
31	StorageLimitNotification
32	CleanupInactiveWorkflowAssemblies
38	ImportSampleData

Next, here’s a list of the different state/statuscodes that each of these operation types can be in:

State	Status	Numeric status value
Ready	WaitingForResources	0
Suspended	Waiting	10
Locked	InProgress	20
Locked	Pausing	21
Locked	Canceling	22
Completed	Succeeded	30
Completed	Failed	31
Completed	Canceled	32

Hope this is useful to you! Have fun with it.