web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Suggested Answer

Cleanup batchjobs

(0) ShareShare
ReportReport
Posted on by 8

Hi All ,

When batch jobs execute, their execution history is stored in the batch job history. This helps in monitoring and validating proper running of (recurring) batch jobs, their execution time and possible logs. However, with a lot of recurring batch jobs, especially those with a high recurrence, will generate a lot of batch job history entries.

AX 2012 R3 has lot of out of box clean up batch jobs and MS suggests to run these batch jobs also as per analysis and client need .

But it's not clearly called out how much it would help to improve performance or other factors ? Can you all share your real world experiences over performance improvement by enabling standard batch jobs ? How can we quantify or measure the performance improvement ?

Further , any additional high volume history data also to be cleaned up apart from MS suggested standard clean up batch jobs to improve performance ?

Thanks in advance. 

I have the same question (0)
  • Suggested answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at

    Hello lally,

    I don't think that you can get a straightforward answer to your question.

    The system performance depends on many things and is highly influenced by the configuration of your system, modifications made, etc.

    You will have to test this to see how much additional 'system power/speed' you get if you clean them up vs. the power/speed that you lose if you don't.

    I believe it is a good practice cleaning them up regularly even though it is very hard to tell you how much you would 'benefit' from this cleanup exactly.

    Best regards,

    Ludwig

  • André Arnaud de Calavon Profile Picture
    301,088 Super User 2025 Season 2 on at

    Hi Lally,

    Like mentioned by Ludwig, there are many different factors which can influence the behavior. You are also not mentioning which processes are in use or not.

    If you want to cleanup the batch history, then this is a job which is quite slow in my experience. For several customers, we did create another script to delete the batch job history. Usually, when the recurrence is set many time a day (e.g. workflow processing per minute), I disable the history and only enable the logging for errors. This saves you from a lot of records and you can focus on the errors only.

  • Suggested answer
    Leo Chen Profile Picture
    on at

    Agree with André to enable logging only for error events of high frequency execution batch jobs.

    In addtion, you can run standard SQL reports like the standard top 10 tables report periodically to figure out which tables are the top tables to consume the most SQL space and might contribute a lot to potential perf degradation of AX2012. 

  • lally Profile Picture
    8 on at

    Thanks for the reply , Andre 

    [quote]I disable the history and only enable the logging for errors. This saves you from a lot of records and you can focus on the errors only.[/quote]

    Above solution already in place in client prod environment for several years.

    [quote]there are many different factors which can influence the behavior. You are also not mentioning which processes are in use or not.[/quote]

    Client runs 24*7 production process with Advance warehouse management .

  • lally Profile Picture
    8 on at

    Thanks for the reply , Leo 

    [quote user="Leo Chen"]standard SQL reports like the standard top 10 tables report periodically to figure out which tables are the top tables to consume the most SQL space and might contribute a lot to potential perf degradation of AX2012. [/quote]

    Above suggestion is also in place in client production environment and most of the cases ,the report highlight about the GL  trans and Invent trans and some other trans tables only ,apparently these tables data never be deleted.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 451 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 428 Super User 2025 Season 2

#3
BillurSamdancioglu Profile Picture

BillurSamdancioglu 239 Most Valuable Professional

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans