RPD customers would benefit from being able to see the status of the database maintenance in the RPD GUIs. This would be a big step towards making Admins aware if their server is going unmaintained or there are problems with the underlying DB before they become big problems for the RPD system.
Exposing more about DB maintenance in the documentation would also be helpful so that customers can understand the reason that it is needed and what we provide for automation so they can decide the best way to ensure their system is running properly.
The RPD Database maintenance is a key element to keeping an RPD system running smoothly. As more customers are taking steps to become security conscious we are starting to get a an influx of accounts where the Database maintenance is unable to run because the system scheduler that kicks it off is not available to the RPD user.
For example an RPD server being installed under a common cloud platform notes the following lines in the thor.log indicating a failure to setup the maintenance schedule on Linux:
Wed Apr 5 14:40:30 2023 - Finalizing crontab...
Wed Apr 5 14:40:34 2023 - New crontab failed to install. Please ensure that the entries in /tmp/aiw.tmp.cron are in the crontab for user aiw1.
Wed Apr 5 14:40:34 2023 - Now leaving main::crontabEntry subroutine
This message often goes unnoticed and unless this customer manually schedules the database maintenance this system will likely start having performance problems in 6-12 months depending on the features installed and load it processes.
This is similar to and expands on RPD-I-367 Show database maintenance status on the GUI.
