Precisely Enterworks

Some EnterWorks repositories contain log information, such as the Change Notification Log (CN_Log) repository.  These repositories tend to grow over time.  EnterWorks does not have an automatic cleanup or purge operation that will remove the oldest records from these repositories.  If left unchecked, the database will eventually fill up with entries and searching for recent entries will take significantly longer.  A SQL Stored Procedure named EW_PurgeExpiredRepositoryRecords has been defined that will remove the records in the designated repository that have not been modified in the designated number of days.  When run on a log repository, this stored procedure will ensure the repository will not continuously grow and retain only the records that are within the specified time period.  This stored procedure can be invoked from a Scheduled Export to automate the cleanup of the repositories. 

This session provides detail on this stored procedure and how to invoke it from a Scheduled Export.

Link: ETT 161 - Cleaning up Expired Repository Records Using SQL and Scheduled Export