Just interested to know how service now is deleting the staging table data ?

[blhaha4]

Just interested to know how service now is deleting the staging table data ?

[Nithish1 · Accepted solution]

Hi Harsha,

The below link will give you more info.

https://docs.servicenow.com/bundle/jakarta-platform-administration/page/administer/import-sets/concept/c_ImportSetsKeyConcepts.html

Import set scheduled cleanup

The Import Set Deleter scheduled job cleans up old import set data every day at midnight.

By default, the job will delete all import sets that are older than 7 days and the associated import set table records. If this scheduled job is not active on your instance, activate it to mitigate the growing import set tables that you may have, especially when using recurring imports.

Note: If scheduled cleanup is not currently active on your system, you must ensure that your import set tables are not too big (> 5 million records total across all tables) before enabling this cleanup. If the tables are too big, manually delete the records first before proceeding. Please contact ServiceNow support to coordinate the deletion of this data.

Thanks,

Nithish

P.S. If my suggestion helped then please mark as helpful and/or correct so other community members can benefit from this information.