Switch Schema and SaaS Batch Scheduler Integration Enhancements

The Switch Schema function allows customers to change from production schema to the staging schema or vice versa to perform various data conversion processes and the SaaS Batch Scheduler performs scheduling and processing of streams of batch jobs that handle various customer's business processes.

In this release, this function checks if a batch job or a scheduler batch stream is running or not when a customer switches a schema then disallows the switch if the batch job or a scheduler batch stream is running. Customers must wait until no batch job or scheduler batch stream is in progress before trying to switch the schema. In addition, when the customer switches the schema and the process is on-going, the SaaS Batch Scheduler now detects this event and pauses all batch scheduling and processing until the switch schema process is complete.

Disallowing schema switching during an ongoing process ensures customers data integrity is maintained in both database schemas.

Steps to Enable

You don't need to do anything to enable this feature.

Tips And Considerations

The Switch Schema function is only available when the cloud environment is in conversion mode. Verify the running batch processes before trying to switch the schema under conversion mode.