All Parts Cost Calculation was run as a background job on 09/11/2024 at 01:30. It completed 10/11/2024 03:10:21 so a total of 25 hours 40 mins.
Previous successful completion 03/11/2024 10:40:24 took nearly 23 hours.
This job had been running regularly taking around 6 hours before November.
There have been some significant changes to product structures recently which seem to have resulted in these extremely long run times.
This is high priority as we are unable to run this job in a timely fashion so it will impact finance timelines to prepare end of month/year reports. Ideally this job needs to run in under 8 hours.
Any advice on changes that can be made to batch queue configuration that may improve this?