|Applies To||RSA Product Set: Archer|
RSA Version/Condition: All
|Issue||The database tables tblDataFeedHistory and tblDataFeedMessage store Data Feed history and run detail messages. These tables can become very large over time. How can these tables be cleaned out so that they only store data for a certain length of time?|
|Resolution||The attached SQL script deletes Data Feed history and run detail data older than 90 days. The notes included in the script provide instructions for changing the retention period.|
Set up a SQL Agent job in SQL Server Management Studio to run the script periodically, such as once per week.