Elastic Jobs
An elastic jobs runs as a cloud service in your Azure environment and allows you to execute a T-SQL script across one or more databases in:
- An elastic pool
- A shard set
- A customer-defined database collection
Elastic jobs can be scheduled as and when required. Job successes and failures are logged for troubleshooting and you can also enable retries after a failure.
Use Cases
Elastic jobs are commonly used for:
- Database Management and Maintenance
Elastic jobs can be used for deploying schema changes across, running database maintenance jobs such as index rebuild, collecting database performance data, or updating reference data in a shard set.
- Reporting
Elastic jobs can be used to aggregate data from a shard set and into a single reporting table. ...
Get Professional Azure SQL Database Administration now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
