A customer upgrading 6.1.4 to 7.1.2, and asked the question "Is there a way to completely turn off the nightly maintenance job in v6.1.4?"
Thank you for your suggestions!
A customer upgrading 6.1.4 to 7.1.2, and asked the question "Is there a way to completely turn off the nightly maintenance job in v6.1.4?"
Thank you for your suggestions!
Hello,
We suggest to never turn off the maintenance jobs as they are there for a reason.
What we often see is that these "tasks" become a nuisance when the overall configuration is incomplete or incorrect with regards to archival. For example, if the "history" tables grow too large then the "shrinking" jobs may run longer than desired. Thus it's very, very important to configure the archival procedure from day one and avoid this problem later on.
Please refer to the Configuration Guide for more information on Archiving Procedure Setup.
Specifically, are the retention periods too long? Is there a History Database in place to store archived data? How large are the history tables, e.g. jobhistory?
Instead of addressing the symptoms, it may be worthwhile to investigate the underlying cause.
The same is true for indexing jobs. If the tables are large, or there is fragmentation, if the SQL server is performing poorly, then these tasks will run long.
Trevor
Trevor and MekindAD,
Thank you for the suggestions!
The reason to stop daily maintenance job is it could last up to 7 hours and nobody can logon to the web portal during that period of time. The 7.1.2 upgrading is on the way so intend to have v6.1.4 WP more robust without downtime. Thank you again!