Microsoft Azure offers the Azure Elastic Job agent as a managed service, enabling efficient scheduling of T-SQL workloads on Azure SQL Databases. Similar to the SQL Server Agent job Wizard in SQL Server Management Studio, Azure Elastic Jobs Manager streamlines job deployment oversight with a Visual Studio extension, allowing seamless management from your desktop. This article demonstrates managing Elastic Jobs in Azure using Azure Elastic Jobs Manager, highlighting its resemblance to the SQL Server Agent job in management capabilities.
Prerequisite: Azure Elastic Jobs service in Azure. In case you do not have the service created, you can follow these steps to