Avatar

Level 3

David__Garcia  I meant this.. from adobe link >> experienceleague.adobe.com/docs/campaign-classic/using/monitoring-campaign-classic/data-processing/database-cleanup-workflow.html?lang=en#cleanup-of-rejects-generated-by-imports-

This step lets you delete records for which all data wasn’t processed during import.

  1. Mass-deletion is carried out on the XtkReject table with the following query:

    DELETE FROM XtkReject WHERE iRejectId IN (SELECT iRejectId FROM XtkReject WHERE tsLog < $(curDate)) LIMIT $(l))

    where $(curDate) is the current server date from which we subtract the period defined for the NmsCleanup_RejectsPurgeDelay option (refer to Deployment wizard) and $(l) is the maximum number of records to be mass deleted.

  2. All orphan rejects are then deleted using the following query:

    DELETE FROM XtkReject WHERE iJobId NOT IN (SELECT iJobId FROM XtkJob)