We have some databases that can take hours to rebuild. These databases are set to rebuild whenever the sync process completes. So in the middle of the day, when working on modifying data being synced or adding additional data to sync, it’s important to pause these builds while the new data is synced and changes made to the DBs.
Currently, the only way I believe to do this is by going to each database and turning off it’s scheduled rebuild, then when complete, turning the schedule back on.
At the very lease, I’d like to be able to select all the database and change the schedule, vs doing each one individually.
An alternative to changing the schedules might be an option to “Pause” builds, then “Unpause” when done. (In the case the schedules vary, you don’t have to remember the schedule setting for each DB)
Ideally would be an option to “Pause for X hours”. What has happened to me in the past is I’ve turned off the schedule on the DBs, spent a number of hours on syncing new data and redesigning DB, and forget to turn schedules back on. I don’t realize it until the next day when I get a bunch of users calling about the data being incorrect.
I know this doesn’t affect a lot of people, but as someone who has been spending a lot of time over the past weeks adding data to Phocas, it would be a huge help!