Introduction
You've learned about some of the capabilities of the SQL Server Agent. SQL Server Agent is also available on Azure SQL Managed Instance. However, if you're using Azure SQL Database, you'll need an alternative scheduling mechanism, as both the msdb database and the SQL Server agent are unavailable.
In this module you'll learn about Azure Automation, Logic Apps, and elastic jobs, three approaches for automating jobs in PaaS. You'll also learn about Azure policy and how it can be used to manage your subscription and costs.
Learning objectives
At the end of this module, you'll understand:
- The benefits of Azure policy
- The capabilities of Azure Automation
- How to use elastic jobs
- How to use Logic Apps