Scheduled Schema Loads

[kxie]

Is there a way to trigger a schema load when another one finishes? I know it is generally best practice to put tables that need to be loaded together into the same schema. However, for security/access reasons I need keep these tables in separate schemas. I would schedule the second schema to start 15 minutes after the first, but the scheduling between times only allows scheduling to start at the top of the hour. 

[dylanwan · Accepted solution]

it is possible to run a schema refresh after another schema refresh by using the data load API via the synchronous mode.  However, the feature is not currently available from the scheduler UI. It is on the roadmap to provide the multiple schema load feature and one scheduled job will have objects from multiple schemas. However, we probably won't run one before the other but allowing them to be executed in parallel with the dependency handled at a more granular level.