Archiving PA Scores

[PiotrekL]

Hi

I want to archive pa_scores as this table is very big. ServiceNow suggests:

Records from pa_scores* and pa_snapshots tables are being cleaned regularly by the Clean PA collections job based on the retention period defined in system properties com.snc.pa.dc.keep_scores_for.frequency and com.snc.pa.dc.keep_snapshots_for.frequency.

But only Job I see is that in the screenshow and I cannot change it and moreover I dont see any script which relates it to menioned sys_properties. 

Please help me how to manage that. 

Regards

Piotr

[Rafael Batistot]

Hi @PiotrekL 

You can control it through system properties, not the job itself:

1. Navigate to System Properties → All Properties.
2. Search for:
   
• com.snc.pa.dc.keep_scores_for.frequency
• com.snc.pa.dc.keep_snapshots_for.frequency
3. If they don’t exist, create them manually (type: integer).
4. Set the value to the number of days you want to retain. Example:
   
• 90 → keep scores/snapshots for 90 days, delete older ones.
• 365 → keep one year.

Important: The unit is days, not months/years.

[kaushal_snow]

Hi @PiotrekL ,

Clean PA Collections Job and Modify System Properties:

ServiceNow includes an out-of-the-box scheduled job named Clean PA Collections, which runs daily (by default) and deletes score and snapshot records older than specified retention periods.

** The retention periods are controlled by two system properties **

com.snc.pa.dc.keep_scores_for.frequency

com.snc.pa.dc.keep_snapshots_for.frequency

These values represent days (e.g., 90 means 90 days of history will be kept).

and lastly, Monitor PA table sizes and logs to confirm data older than the threshold is being removed over time.

If you found my response helpful, please mark it as ‘Accept as Solution’ and ‘Helpful’. This helps other community members find the right answer more easily and supports the community.

[Ravi Gaurav · Accepted solution]

Hi @PiotrekL 

You can control retention by changing the properties:

Go to: System Properties → All Properties

• Search for:

  • com.snc.pa.dc.keep_scores_for.frequency

  • com.snc.pa.dc.keep_snapshots_for.frequency

    Default value is usually 90 days.
    Example:

    • If you set com.snc.pa.dc.keep_scores_for.frequency = 30 → scores older than 30 days will be deleted when the job runs.

    • After changing, wait until the next Clean PA collections job execution, or run it manually from System Scheduler → Scheduled Jobs.