NmsAddress Clean up

asktam1410

21-11-2019

I would like to know on what scenario records will be deleted from the address table. I see that records are being deleted from this table but dont know on what reasons it deletes.

Accepted Solutions (1)

Accepted Solutions (1)

Venu_Reddy

MVP

21-11-2019

Hi

In NmsAddress schema, usually the blacklisted,quarantine, valid, whitelisted data will be available.

The valid address will be automatically removed from this table using the option NPAI (NmsCleanup_LastCleanup) which is a part of clean up process.

This task lets you delete records which matches valid addresses from the NmsAddress table.

Check below link for the query how it will process

Database cleanup workflow