Optimize 10.5 | webMethods Optimize Documentation | Administering webMethods Optimize | For Database Administrators | Purging Data from Optimize Database Components | Using Data Purge | Running Data Purge | SQL Server
 
SQL Server
Optimize purges data from databases in SQL Server by calling a stored procedure from an MSSQL database client. This procedure purges data by issuing DELETE statements.
*To run Data Purge in SQL Server
1. The stored procedure call is:
exec data_mgmt_purge_data
2. Avoid aborting a data purge procedure because doing so can affect foreign key constraints. Data purge in SQL Server disables constraints one at a time. If the data_mgmt_purge_data procedure for SQL Server fails or is aborted, call this stored procedure to restore all Foreign Key constraints:
EXEC db_mgmt_modify_dependant_fk_constraints_all 'CHECK'
Important:
If the Analysis and Process Tracker database components are in separate schemas, the Data Purge must be executed in each schema separately.