We are excited to announce the availability of a new, significantly upgraded public preview release ofAzure Elastic Database jobs. Elastic Database jobs is now a fully Azure-hosted service. Unlike the earlier, customer-hosted and managed version of Elastic Database jobs, this version is an integral part of Azure with no additional services or components to install and configure. This release also adds significant capabilities making it easy for customers to automate and execute T-SQL jobs using PowerShell, REST, or T-SQL APIs against a group of databases. These jobs can be used to handle a wide variety of tasks such as index rebuilding, schema updates, collection of query results for analytics, and performance monitoring.
Imagine you are a SaaS developer in the cloud offering online ordering services for a collection of large stores. To support this and allow unlimited scale, you’ve provisioned separate Azure SQL databases to handle each store’s business, and this set of databases share a common schema. While your application directs customer transactions to the appropriate store’s databases, you want the capability to easily manage all databases jointly to ensure the performance and customer experience remain optimal. Additionally, you periodically have new schema to deploy to each database in preparation for a new feature you are planning to integrate into your application for your customers.