Running the Maintenance SQL Script

Use a SQL script to maintain the Archer database if your organization does not have its own standard process for maintaining Microsoft SQL database indexes and statistics. This script creates the Archer Database Statistics Update job to update statistics and the Archer Database Index Rebuild job to re-index the database.

For best results, schedule these jobs to run during inactive periods. For example, you can schedule the Statistics Update job to run every day at 3:00 AM and the Index Rebuild job to run every Sunday at 2:00 AM.

Note: The SQL Server Agent must be running before you can execute the script.

Run the Maintenance SQL Script

1. Log in as a system administrator to the server that hosts the Archer database.
2. Navigate to the \RSA Archer\Tools\ folder.
3. Double-click jobDeployScript.sql.
4. Select the Archer database as the current database.
5. Execute the script, which creates the Statistics Update and Index Rebuild database jobs.