The customer has lots of data in some tables - mostly quality assurance related, traceability - and keeps only last 3 months of data in the main tables.
They have already setup archiving which works okay, except it started to get too slow mainly because it takes the rows in the head table one by one.
As it does not put a big load on the storage we tried find some option to do it parallel, meaning several archiving jobs (orders) could run for these tables with different filters at the same time.
But we found that the jobs are executed one after another:
Is there a way to make them run parallel?