New feature - "Job history cleanup" batch job for Data management and other cleanup routines in Dynamics 365 for Finance and Operations

In this blog I would like to explain about the new batch job introduced in data management to clean up execution history and other list of clean up jobs which are available across modules in Dynamics 365 for Finance and Operations. 

Please check the list of clean up jobs in D365FO in Microsoft blog

Cleanup routines in Dynamics 365 for Finance and Operations 

And the most awaited clean up job has been released for Data management module (available in Platform update 29 and later), which is very important for most of the business as every business uses Data management (Integration, Data Migration or BYOD etc..) and this should be scheduled to clean up data regularly, else we end up with performance issues.

This “Job history cleanup” clears information from following tables.

•   All STAGING TABLES
•   DMFSTAGINGVALIDATIONLOG
•   DMFSTAGINGEXECUTIONERRORS
•   DMFSTAGINGLOGDETAIL
•   DMFSTAGINGLOG
•   DMFDEFINITIONGROUPEXECUTIONHISTORY
•   DMFEXECUTION
•   DMFDEFINITIONGROUPEXECUTION   

The functionality must be enabled in feature management and then can be accessed from Data management > Job history cleanup.

      1.     Please go All workspaces > Feature management and select “Execution history cleanup” and enable.

        2. Once we enable this feature then we should be able to see new tile called "Job history clean up" added to Data management module.

This can be run as batch job with following parameters setting up.

•   Number of days to retain history
•   Number of hours to execute the job
•   Recurring batch

For more information check Microsoft documentation.

Tags, 

#D365FO, #DataManagement, #CleanUp, #Clear, #DeleteExecutionHistory, #JobHistoryCleanup