The EBMS software contains many powerful maintenance utilities to maintain data integrity. EBMS Utilities check and correct the internal consistency of the EBMS database. Sources of inconsistency include software bugs, uncontrolled server restarts, and hardware errors. In addition, the reindexing utility eliminates fragmentation and optimizes the database table indexes for best performance.
An EBMS administrator who schedules Automated utilities does not need to remember to manually initiate them, nor do they need to be connected or even awake during the company's regularly scheduled maintenance window.
Complete the following steps to setup maintenance utility schedules:
Launch the EBMS Server manager: See EBMS Server Manager Overview for details on this utility.
Select the Settings
from the Server manager navigator left bar and click on the Maintenance tab as shown below:
Set the Companies to run on option to All if the server only contains one main data set. The user many wish to schedule one company each night if the server contains multiple large data sets.
Enter the EBMS administrator's e-mail address into the CC Utilities result emails to box. Separate multiple emails with a semicolon.
Click on the Add new maintenance task link to crate a new scheduled task as shown above. Select the Run all utilities option unless the user wishes to schedule the utilities and the reindex utility at different times.
Enable the Force disconnect of all users (all companies) option to remove the possibility of a conflict from active users.
The Date range setting determines the range of months that will be included in the utility process.
Click on the Run this task now button to launch the task now.
Repeat the steps to create additional scheduled maintenance tasks if the utilities, reindex processes, or maintenance utilities are launched for multiple data sets at different times.