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.
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. The reporting table can then be fed to Power BI, SSRS, or any of the reporting or visualization tools for creating reports. Normally, you would have to connect to each and every shard in a shard set to run the report query and insert the...