Automate Database Maintenance

Purpose

This solution provides an easy way to maintain and log any desired database maintenance tasks, with room to grow and expand if necessary.

Associated Content

Content	Type	Function
CWM - Automate - Script - Automate Database Maintenance Solution	Script	This is a wrapper script that calls all database maintenance subscripts and creates the log file.
CWM - Automate - Script - Automate Database Maintenance - Commands	Script	Cleans up old commands
CWM - Automate - Script - Automate Database Maintenance - Drives	Script	Cleans up missing drives
CWM - Automate - Script - Automate Database Maintenance - EventLog	Script	Cleans up old event logs
CWM - Automate - Script - Automate Database Maintenance - Monitors	Script	Cleans up old monitors
CWM - Automate - Script - Automate Database Maintenance - Network Devices	Script	Cleans up old network devices
CWM - Automate - Script - Automate Database Maintenance - Roles	Script	Cleans up old roles
CWM - Automate - Script - Automate Database Maintenance - Script History	Script	Cleans up script history
CWM - Automate - Script - Automate Database Maintenance - Tickets	Script	Cleans up ticket-related data
CWM - Automate - Script - Automate Database Maintenance - UserCentric	Script	Forces contacts to be managed for user-centric
CWM - Automate - Script - Automate Database Maintenance - User Class Permission Sync	Script	Forces default user class permissions to all clients

Implementation

NOTE: This solution deprecates Proval Maintenance[Globals] (6794)

1. Import the CWM - Automate - Script - Automate Database Maintenance Solution script.
2. Ensure the other scripts are also synced and fully up to date. (The main script should import them, but syncing them will ensure we know when they are out of date.)
3. Schedule the client script CWM - Automate - Script - Automate Database Maintenance Solution to run weekly, every Monday at 5:30 AM.

FAQ