EnterWorks

Welcome to the EnterWorks™ Software community!  Please feel free to start a discussion in the discussion tab or join in a conversation.

Here are some useful links where you can find more information:

Product Documentation  Ideas Portal

Discussions

Members

Resources

Events

 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.
    ------------------------------