I want to be able to use Az cli in a Powershell script being run as a SQL Server Agent job. However, I haven't been able to install the CLI for the SQL Server Agent service. How can I install this for the SQL Server Agent or otherwise accomplish this? (I might need to install another utility afterward to compress a file as well.)
I attempted to run the given PS Script in a SQL Agent Job. I attempted to run with a PSSession as the NT Service\SQLSERVERAGENT user (I don't know that I set the session up properly). I attempted to set the Execution Policy to LocalMachine before running the MSI from powershell.