Does Rockwell recommend running the Database Cleanup Wizard for AssetCentre periodically or on an as-needed basis?

It should be run periodically. The logs and archives can be exported to a stand-alone database as part of the cleanup. It is not possible to re-integrate the exported data into the active database.