Elastic Database Jobs

Elastic Database Jobs or Azure-hosted Elastic Database Jobs can be used to schedule a T-SQL task such as index maintenance against an Azure SQL database, a group of SQL database elastic pools, or an Azure SQL database shard.

An Elastic Database Job can span multiple databases in the same subscription or in different subscriptions.

Note

Customer-hosted Elastic Database Jobs are deprecated. To find out more about migrating existing customer-hosted database jobs to Elastic Database Jobs (Azure hosted), refer to the following link: https://docs.microsoft.com/en-us/azure/sql-database/elastic-jobs-migrate.

The following diagram illustrates the different components of an Elastic Database Job:

Figure 7.13: Different components of an Elastic Database Job

Elastic Job Agent

An Elastic job agent is an Azure resource that's responsible for creating, executing, and managing jobs.

Job Database

An existing clean (blank) Azure SQL database of the Standard (S0) or a higher...