4Configure and Manage Automation of Tasks

• 4.1Automating Tasks with Jobs

  Understand ways to automate routine operations—SQL Server Agent (VM/Managed Instance), Elastic Jobs (Azure SQL Database, across many DBs), and Azure Automation. The mechanism depends on the deployment.

• 4.2Configuring Alerts and Notifications

  Understand alerts that fire on metric/log conditions, action groups for notification/automated response, and notifications on job failures. Detect issues early and respond automatically to stabilize operations.