Here is a scenario for you to ponder..
- You have a separate database with accounts in them that need to be uploaded to MSCRM.
- You use the DDM or write your own application to load the data into MSCRM
- You use the key (a GUID) from the data being imported as the new key in CRM. Yes you can pass in the key GUID you want to create the record for.
- You realize you need to make some changes.
- You delete the records in MSCRM using the screens
- You try the import and it fails telling you you have a duplicate key.
- You search the screens thinking you did not delete them only to find out you did.
What happens when you delete a record in MSCRM is that the record is flagged with a 2 in the deletion State Code and a daily job runs that will clean up and perform all of the deletions.
So no the question, how do you force the deletion job to run NOW.
Well it is not hard.
Run the following SQL on your SQL Server
USE MSCRM_CONFIG
UPDATE ScaleGroupOrganizationMaintenanceJobs
SET NextRunTime = getdate()
WHERE OperationType = 14
then restart the Microsoft CRM Asynchronous Service
I would suggest that after you are done you revisit this and set the next date/time to sometime in the evening well before backups so that the job runs normally after hours.