In on-Premise, we have an SQL agent to perform all the DBA activities in multiple databases like rebuild index, schema changes, etc.
For Example, we have a Product and we have multiple databases for multiple customers now we need to change one table schema in all the databases, How can you do it On-premise?, How can you do it in Azure?
Elastic database jobs or Azure-hosted elastic database jobs can be used to schedule a T-SQL task such as index maintenance against an SQL database, An elastic database job can span multiple databases in the same subscription or in different subscriptions.
Join the group: t.me/sqlbrainbox
Book 1:1 Call: topmate.io/nirav_gandhi
Follow me on LinkedIn: / niravgandhisql
Azure SQL DBA Videos: • Free Azure SQL DBA Tra...
Create an Azure Account: azure.microsoft.com/en-in/free/
Azure Document:docs.microsoft.com/en-in/azur...
#elastic job agent #Azure SQL #Elastic Jobs
Негізгі бет Ғылым және технология Elastic Jobs in Azure SQL Database | 🔥 Free Azure SQL DBA Training 🔥
Пікірлер: 38