Azure SQL Elastic Jobs management

[EitanBlumin]

Summarize Command's Functionality'

With the rise in popularity of Azure SQL databases, there's also rising need in Elastic Jobs.

It would be terrific if there would've been a set of cmdlets in dbatools that would make it much easier than it currently is.

Is there a command that is similiar or close to what you are looking for?

No EDIT: Actually Yes, the *-DbaAgentJob* cmdlets

Technical Details

https://techcommunity.microsoft.com/t5/azure-sql/elastic-jobs-in-azure-sql-database-what-and-why/ba-p/1177902

[potatoqualitee]

Agreed! Seems this would be a wrapper module around Az.Sql, however, which would be a new azure-centric module that depends on dbatools and az.sql. Which command would you like to see first?

[EitanBlumin]

I would love it if there would've been a single cmdlet responsible for setting up an Elastic Jobs Agent if it doesn't exist already.

And also the Elastic Jobs equivalent of New-DbaAgentJob, New-DbaAgentJobStep, etc.

[wsmelton]

For proper support with Azure services would it not be advisable to use their commands and workflows for this process?

https://docs.microsoft.com/en-us/azure/azure-sql/database/elastic-jobs-powershell-create

[EitanBlumin]

@wsmelton , the same thing could be said about any other task implemented by dbatools.

For proper support with SQL Server would it not be advisable to use Microsoft commands and utilities for any process?

The answer is: Of course!

But wouldn't it be awesome if dbatools made it so much easier and accessible?

[wsmelton]

I prefer to use automation tools that give more consistent deployment options such as ARM and Bicep. The same use case as to whether you use DSC or dbatools to deploy SQL Server. They each have their purpose but for Azure resources, I'd chose the stronger tooling 🤷🏻 .

In any case, this would not be something dbatools would not do as Chrissy already stated it would be in a separate module.

For proper support with SQL Server would it not be advisable to use Microsoft commands and utilities for any process?

Microsoft recommends our module now 😉 .

[EitanBlumin]

Microsoft recommends our module now 😉 .

Well, yes, but we didn't get this far by preferring to stick with existing MS tooling, right?