Post a question

News and Announcements icon

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... Batch table clean-up

Finance | Project Operations, Human Resources, ...

Suggested answer

Batch table clean-up

Like (0) Share

Report

Report

Posted on 22 Mar 2023 11:01:25 by Tommaso B.

5

Hi All,

Is there any cleanup routine to clean the BATCH table?

Batch table for us is geting very big, 70GB at the moment.

I see that there are standard function for the BATCHHISTORY and BATCHJOBHISTORY, but nothing for BATCH

Thanks in advance for any advice

All responses Img

All responses (2)

Answers Img

Answers (0)

Suggested answer

Charlotte X on 23 Mar 2023 at 01:35:07

Like (0)

Report

RE: Batch table clean-up

Hi Tommaso,

The following are standard cleanup routines.

Cleanup routines in Dynamics 365 Finance and Dynamics 365 Supply Chain Management - Finance & Operations | Dynamics 365 | Microsoft Learn

In addition to these, other clean job requires customization.
nunomaia 11 Moderator on 22 Mar 2023 at 11:10:30

Like (1)

Report

RE: Batch table clean-up

Not a standard job. We create a custom clean job for that.

Not official recommendation by Microsoft is to keep that table under 10 GB

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 292,865 Super User 2025 Season 1

#2

Martin Dráb 231,723 Most Valuable Professional

#3

nmaenpaa 101,156 Moderator

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans