System Administrator Cleanup Procedures

A stored procedure named usp_NTS_NOTIFICATION_PROCESS_CLEANUP has been provided for your convenience that can be modified/scheduled based on the needs of your organization. The purpose of this procedure is to clean up NTS related tables, such as the sent message table, NTS process, and NTS process detail tables, and potentially other tables you may choose to include as they relate to the NTS subsystem. This procedure does not run as part of the NTS windows service but rather it is provided to you for scheduling as part of the SQL Server agent service in order to purge historical data from your system on a schedule to be defined by your organization.