Precisely Enterworks

 View Only
Back to discussions
Expand all | Collapse all

EW_PurgeHistoryRecords stored procedure updated to support comma-delimited list of repositories

  • 1.  EW_PurgeHistoryRecords stored procedure updated to support comma-delimited list of repositories

    Employee
    Posted 08-12-2025 15:12

    The stored procedure EW_PurgeHistoryRecords provided in the EnterWorks Tech Talk: "ETT 149 - How to Clean Up History Records for Scheduled Job Repositories Using SQL" has been updated to accept a comma-delimited list of repositories in addition to wildcards.  This eliminated the need to define separate Scheduled Export jobs for different repositories to share the same "expiredDays" cutoff that cannot be identified with wildcards.  It also eliminates the need to create an "executive" stored procedure that calls this stored procedure for such cases.  Now a single View Scheduled Export can be defined for each unique "expiredDays" cutoff to keep the referenced repositories' history records from continuous growth.

    Link:  ETT 149 - How to Clean Up History Records for Scheduled Job Repositories Using SQL



    ------------------------------
    Brian Zupke
    *Precisely Software Inc.
    ------------------------------