Maintenance Manual

72 Enterprise Chat and Email Deployment and Maintenance Guide
Additional Tasks for Database Servers
In addition to the routine maintenance tasks that apply to all the ECE servers, there are some special tasks for the
database server that are described in this section.
Performing Disk Defragmentation
 Weekly defragmentation is recommended. Note that it requires downtime.
Monitoring Summarization Job Runs
On a weekly basis, verify that all the summarization jobs enabled for ECE are running successfully at the
scheduled times.
To view the summarization job run details:
1. In the Microsoft SQL Server Management Studio, browse to SQL Server Agent > Jobs.
2. In the jobs list, locate the job populatesmy_
Database_Name. Where Database_Name is the name of the active
database (in SQL Server Standard installations), or the reports database (in SQL Server Enterprise
installations).
3. Right-click the populatesmy_
Database_Name job and from the menu select View History.
4. In the Log File Viewer window, browse to Job History and check the following:
 In the Date column, the date and time should not be very old as jobs run every 30 minutes.
 For all successfully run jobs, the date column will show a green check mark.