Creating a better "Daily/Weekly/Monthly System Maintenance Tasks" list.

[Ryan_Wakefield]

Hello everyone,

So I have been working on putting together a list of all of the different System Maintenance Tasks that should be and can be performed on the OnBase system. Now yes, I am well aware of the items that are in the System Administration MRG. However, I want to go beyond that and get a more detailed list.

GENERAL Maintenance

Daily

• Confirm Successful Daily Backups
• Confirm Successful Database Backup
• Confirm Successful Database Transaction Log Backups
• Check Source Directories
• View SYS Unidentified Items
• Check Windows Event Viewer
• Check Document Locks
• Check Process Locks

Weekly

• Confirm Successful Weekly Backups
• Confirm Removable Media to Off-Site Location
• Record the Size and Free Space of the SQL Transaction Log Table
• Record the Size and Free Space of the OnBase Database
• Record the Size and Free Space of All Disk Groups
• Record All Free Space on Remaining Drives
• Run All System Configuration Reports
• Capture Performance Metrics
• Rebuild Database Indexes

Monthly

• Purge OnBase Transaction Log
• Confirm Successful Monthly Backups
• Confirm Tape Rotation to Off-Site Location
• Test Ability to Restore Files from Backups
• Test Ability to Restore OnBase Database
• Consider Rebooting All Servers
• Communicate with Local IT Staff
• Communicate with OnBase Users
• Communicate with Your Solution Provider

So what System Maintenance tasks do you perform? As well, are those maintenance tasks specific to your industry or are they more general like the ones above?

[Shawn_Varney1]

we have clinical barcode processes running that we verify daily are not "stuck", which is an additional step to the process and document locks. If there is anything left over from the previous day, we will "skip processing" to have these fall into the scan queue for manual indexing

[Kirk_Sumpter]

A couple we do:

Nightly:

recycle the application servers (3:00 AM, scheduled via windows task)

Daily (morning):

- Check all thick client services launched and are running, no errors noted from day before

-  Verify all batches committed in DIP/DRIP/COLD

- check SYS - Unidentified Items to verify no documents

Weekly (Friday)

- Run configuration reports (Config - Reports - Run All Reports)

- Delete empty folders in Record Management (Thick Client - Admin - Records Management - Administration)

[Mike_Maxson]

Hey Ryan,

Couple items I review every morning but some items I am unable to do as the Database Backups are controlled by the DBA Team.  What I do may be overkill but I have seen Unity Scheduler Tasks for Workflow Timers go into an error state and you have no clue as the Unity Scheduler Service is still running.

Check Workflow Timer Services
Geocortex Alarm Notifications - Monitoring Software we have on Servers
New Relic Alerts - Monitoring Software we have on Servers
Party-Information Auto-fill, Process
Checking Source Directories for Auto-fill Jobs
Reviewing Verification Reports for Party Information Autofill
Check Windows Event Viewer logs on Servers - (This is interesting after going from v13 to v18)
Checking Document Locks
Checking Process Locks
Checking Workflow Queue Counts - High Volume Workflow Queues

Thanks,

Mike

[Ryan_Wakefield]

How often do you guys go through the incomplete commit and incomplete delete queues? I have heard somewhere to do this monthly, but curious what others have done.