Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

 Mark Huseboe (MarkH960)
Ameriprise Financial

Ameriprise Financial
US
MarkH960 Member since 2012 50 posts
Ameriprise Financial
Posted: Feb 28, 2018
Last activity: Mar 2, 2018
Posted: 28 Feb 2018 11:55 EST
Last activity: 2 Mar 2018 13:24 EST
Closed
Solved

sppr_purge_table

Is there a documented list of the tables that get sent to this stored proc?

From our alert log and some posts on pdn, I can tell that the following are sent, but I would like to get a full list. Here are the ones I know about:

pr_log

pr_perf_stats

pr_log_reportstats

pr_log_systemstate

pr4_log_rule_usage

Also, where can I obtain the actual logic within sppr_purge_table?

Thanks.

***Edited by Moderator Marissa to update categories***

To see attachments, please log in.
Data Integration
System Administration

Accepted Solution

Posted: 6 years ago
Posted: 2 Mar 2018 0:30 EST
Madhuri Arugula (arugm)
PEGA
Principal Cloud Development Engineer, Platform Deployments
Pegasystems Inc.
IN

Hi Mark

These are some of the tables that are groomed using the stored procedure.

pr_log_reportstats, pr_perf_stats, pr4_log_rule_usage, pr4_log_rule_usage_detail, pc_events, pc_pegatask

Other tables that are purged by system cleaner and elsewhere do not use this method.

This stored procedure is basically used for purging the tables. You can find more details in corresponding database ->Programmability->Stored Procedures

-Madhuri 

To see attachments, please log in.

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice