Azure Elastic Database Jobs is Now in Public Preview!

Azure Elastic Database Jobs is now in public preview!

As of June 27th Azure Elastic Database jobs were released. Elastic Database jobs is now a fully Azure-hosted service which is unlike earlier versions of this. It does not need any additional components to install or configure. The latest release also includes new capabilities such as; Easy automation and execution of T-SQL jobs using PowerShell, REST, or T-SWL APIs against databases. These jobs can be used to handle a wide range of tasks such as index rebuilding, schema updates, the collection of query results used for analytics and performance monitoring.

As new customers are added or dropped additional databases need to be created and dropped without the hassle of having to change the maintenance job scripts. Azure Elastic Database allows this to be achieved by using T-SQL based job scripts. These jobs can be scheduled, run, managed and monitored using T-SQL, PowerShell, REST APIs and the Azure Portal.

Some of the features and enhancements of these release include:

  • Elastic Database jobs are now fully integrated into Azure.
  • Jobs can now target databases in more than one Azure SQL elastic pools, logical servers, shard maps and over multiple subscriptions.
  • Jobs can be made of multiple steps to customise the execution sequence.
  • The list of target databases in the target groups are dynamically enumerated. Any database that are dropped from the target group are automatically picked up without having to make job script changes.
  • Jobs can be configured to limit the number of databases a job runs against to help with resource optimisation.
  • Target groups can be customised with ‘Include’ or ‘Exclude’ database, pools or server specific references.
  • T-SQL, PowerShell, REST APIs and Azure Portal support.

About the author