Introduction
If you're proficient in SQL Server, you're likely familiar with 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 evaluate different strategies for monitoring your automation tasks. This includes setting up alerts and notifications to stay informed about job statuses and system errors, using performance metrics to track the effectiveness of your automation, and employing tools to troubleshoot and optimize your automated processes