Support for new features available for SQL Database Elastic Job Agent (Preview)

[geremy42]

Is there an existing issue for this?

• I have searched the existing issues

Community Note

• Please vote on this issue by adding a 👍 reaction to the original issue to help the community and maintainers prioritize this request
• Please do not leave "+1" or "me too" comments, they generate extra noise for issue followers and do not help prioritize the request
• If you are interested in working on this issue or have submitted a pull request, please leave a comment and review the contribution guide to help.

Description

New annoucements (at last!) has been recently made concerning Azure SQL Database Elastic Job Agent:

• Microsoft Entra ID (formerly Azure Active Directory) support
• Service-managed Private Link support to securely connect to target databases.
• Integration with Azure Alerts for job execution status
• Easily scale Job Agent’s tier to connect to more targets concurrently.

New or Affected Resource(s)/Data Source(s)

azurerm_mssql_job_agent, azurerm_mssql_job_credential

Potential Terraform Configuration

resource "azurerm_mssql_job_agent" "example" {
  name        = "example-job-agent"
  location    = azurerm_resource_group.example.location
  database_id = azurerm_mssql_database.example.id
  sku        = "JA_100"
  identity {
    type         = "UserAssigned"
    identity_ids = [azurerm_user_assigned_identity.example.id]
  }
}

References

https://techcommunity.microsoft.com/t5/azure-sql-blog/azure-sql-database-elastic-jobs-preview-refresh/ba-p/3965759

[tombuildsstuff]

Dependent on #23721 / Azure/azure-rest-api-specs#26619

[okruga]

I believe it's possible to proceed with this, isn't it?