Archive Rule not archiving complete batch

[Pooja991]

I have set the archive properties as following:

But the archival batch per run is 1000 per iteration. As per our requirement we have to archive 6lk+ records from one of the table and with this rate it is taking huge time. Can anyone provide any solution for quick archival.

[Community Alums]

Hi @Pooja991 ,

By default an archive rule follows these processing rules:

• Archives 100 records for each batch job
• Sleeps 1 second between batch jobs
• Runs 10 batch jobs in an archive run (every hour)

If you change the interval of job from 1 hour to some lower value, job may sometimes not finished in 1 hour and hence it will not run but if archive threads will pick up to run on other node it can cause problems.

You still have option to run 10 batch jobs every hour and 100 records per batch job (1000 records). And performance of job depends on several factors like size of table, indexes, performant queries and instance config. So before moving forward I would recommend to clone one subprod from prod and check the performance if archive job.

Also, refer to this KB : https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0684703

[Pooja991]

Hi @Community Alums ,

So as per the details shared by you, even if we change the batch size for the archival process, it will still take the default value instead of the updated size?

Please provide confirmation, if this is the correct understanding.