Enterprise Vault™ Housekeeping for the Monitoring Database

Last Published:
Product(s): Enterprise Vault (14.1, 14.0, 12.5, 12.4, 12.3, 12.2, 12.1, 12.0, 11.0.1, 11.0)

Manually running the purge job SQL script file

Use the following procedure to manually create the SQL job to perform the purging of the Monitoring database history records.

Note:

This procedure is only required if you did not assign the additional roles and permissions to the Vault Service account before you ran the Enterprise Vault Configuration wizard for the first time.

To run the purge job SQL script file

  1. Make sure that you have set up the appropriate permissions for the Vault Service account.

    See Assigning the roles and permissions to the Vault Service account.

  2. Make sure that the status of the SQL Server Agent service is "Started" for the SQL Server that hosts the Enterprise Vault Monitoring database.
  3. Start SQL Server Management Studio.
  4. From the File menu, open the file EVOMDB_7_PurgeJob.sql in the Enterprise Vault installation folder, typically C:\Program Files\Enterprise Vault.
  5. Press F5, or select Query > Execute to execute the SQL script.

    After a short time, SQL Query Analyzer or SQL Server management Studio should indicate that the command completed successfully.