Implement Azure SQL Elastic Jobs with PowerShell

In this article, I will work you through the process of creating elastic jobs in Azure using PowerShell. The elastic jobs are similar to regular agents jobs in SQL Server although they add extra functionality like for example dedicated target groups that can be used in the job step level.

Currently, the elastic jobs are in preview and some of the activities described here cannot be done via Azure Portal (cannot add jobs or target groups for example).


Most of the tasks can be achieved with the Azure cmdlets, but I am also using some dbatools commands to execute