What should you use to schedule the nightly jobs to meet the technical requirements?

What should you use to schedule the nightly jobs to meet the technical requirements?
A . Migrate the SQL Server Agent jobs.
B . Create an Azure Scheduler task.
C . Create an Azure runbook.
D . Implement an Elastic Database jobs.

View Answer

Answer: C

Explanation:

Azure Automation can play the role of SQL Server Agent for Azure SQL DB. Built into the Azure platform is Azure Automation and to get started, you have to create an automation account. You’ll need to provide a name for the account, select your subscription, resource group, location, and determine if you want to create an Azure Run As account. Once you create your account, you can then start creating runbooks. You can do just about anything with the runbooks. There are numerous existing run books that you can browse through and modify for your own use, including provisioning, monitoring, life cycle management, and more.

Scenario: After the migration to Azure, the business process must be scheduled to execute nightly at midnight Eastern Time (UTC-5). The implementation of the business processes must minimize administrative effort.

Reference: https://sqlperformance.com/2017/06/azure/automation-methods