After a long time running reports using DSM Reporter, the number of result tables in the database may be increasing. This document provides a T-SQL script, to automate cleaning up DSM Reporter result tables and views that may have accumulated over time. By using the script, it avoids the user from having to manually cleanup the aged result tables using the DSM Reporter GUI, or manually cleaning up these objects from SQL.
All versions of Client Automation using a Microsoft SQL database.
Run the following script in MS-SQL, against the MDB for Client Automation. Set the variable "@numdays" to the desired age of report results to be cleaned up: