Use Az Powershell module on SQL Managed Instance SQL Agent Job

Question

Is it possible to use the Powershell Az module in an SQL Agent Job on Azure SQL Managed Instance? If so can anyone offer an example?

The notes on this page say "Importing external modules, such as dbatools and dbachecks, are not supported." but I thought being an Azure thing it might be different?

https://learn.microsoft.com/en-au/azure/azure-sql/managed-instance/job-automation-managed-instance?view=azuresql

Answer 1

Hi @TimB-0073 ,

Welcome to Microsoft Q&A platform and thanks for using Azure Services.

As Powershell is part of the underlying architecture,

Powershell is not supported on SQL Agent Job in SQL Managed Instance.

Reference Link: job-automation-managed-instance

Hope this will help. Please let us know if any further queries.

------------------------------

• Please don't forget to click on or upvote button whenever the information provided helps you.
  Original posters help the community find answers faster by identifying the correct answer. Here is how
• Want a reminder to come back and check responses? Here is how to subscribe to a notification