Microsoft Dynamics CRM (Archived)

How to Delete Bulk delete Jobs in MS CRM

(0) Share

Report

Posted on by SachinLade

120

Hello,

I have completed bulk delete jobs in MS CRM. I need to delete them. Is there any way to delete these in MS CRM?

Any help would be much appreciated !!!

Regards,

Sachin

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (0)

Suggested answer

Royal King 27,686 on at

Like (0)

Report

create another bulk delete job by choosing entity as system jobs with condition system job type equals bulk delete. Once this bulk delete job completes it will clear all bulk delete entries except the current one.

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

Hi Sachin,

I agreed with the chitra approach but the condition should we like system job name instead

of system job type because type will delete all the rules for bulk deletion.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Sachin,

Please let me know if the above suggestions worked?

Or else there is a script we can run against the Org DB to delete it from CRM.

Thanks!

Was this reply helpful? Yes No
Suggested answer

Aman Kothari on at

Like (0)

Report

Hi Sachin,

You can delete user created bulk records using below code

QueryExpression bulkExpression = new QueryExpression()

{

//System Job logical Name ="asyncoperation"

EntityName = "asyncoperation",

ColumnSet = new ColumnSet(new string[] { "asyncoperationid", "name" }),

Criteria ={

Conditions=

{

//For Bulk delete operation type is 13

new ConditionExpression("operationtype", ConditionOperator.Equal, 13),

//only get records where systemuser is not "SYSTEM"

new ConditionExpression("ownerid", ConditionOperator.NotEqual, "SYSTEM user Guid"),

//you can also add more custom condition here

}

}

};

var GetUserCreatedBulkRecords=_service.RetrieveMultiple(bulkExpression);

foreach(var record in GetUserCreatedBulkRecords.Entities)

{

//Delete bulk records

_service.Delete("asyncoperationid", new Guid(record["asyncoperationid"].ToString()));

}

Hope it'll help you.

Thanks

Aman Kothari

Blog LinkedIn

Was this reply helpful? Yes No
Suggested answer

Vipin J 1,603 on at

Like (0)

Report

If it is on-Premise deployment you can try SQL query to delete the system job.

Refer here - support.microsoft.com/.../performance-is-slow-if-the-asyncoperationbase-table-becomes-too-large

Was this reply helpful? Yes No
Cristian Mihai 35 on at

Like (0)

Report

Using the SQL will be the unsupported by Microsoft way

Was this reply helpful? Yes No