ScribeMaintenance.sql

Note: TIBCO recommends using the Scribe AdminServer service execution log file cleanup features, added for Insight v7.7. For more information see Managing Execution Log Table Sizes

The ScribeMaintenance.sql script is used to perform regular maintenance on the Scribe Internal Database.

Using the ScribeMaintenance.sql script, you can:

Specify the time interval at which the script should run.
Specify the name of the Scribe Internal Database.
Specify the number of days to keep the database logs (default is 90).
Clean the following:
- Execution log
- Transaction errors log
- Alert log
- Compare log
Update database statistics.

This script can be automated using a Scribe Time Integration Process or any other SQL job scheduler utility, such as SQL Agent. It should be customized to fit your needs and can be broken apart to be scheduled on different intervals.