Automate process to control access to BO data source
We have 1 of the oracle data sources used by BO 4.1 for reporting. Everyday this data source must be refreshed with new data at a specific hour.
During these data refresh hours, we want to hold off all BO reporting to just this particular data source. Today, we automate a process to disable the BO adaptive job server to gate any scheduled jobs from running until data refresh is done. However, we are not able to gate/stop the fresh-on-demand jobs to connect to just this data source.
We are seeking sound advices from the gurus for a solution to achieve this task with automation (command line/script driven), whether it's done on the BO server or on the Oracle DB server.
Thank you in advance for your tips/thoughts.