Azure Automation
An Azure service that is used to automate, configure, and install updates across hybrid environments.
1,366 questions
Hi @Ed Summ ,
Hopefully, this helps you.
How to schedule a Powershell script to run automatically in the Azure CLI each day?
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(60.8, 20%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EES%3C/text%3E%3C/svg%3E)
Ed Summ
1
Reputation point
I have written a Powershell script which removes firewall rules that match specific naming conditions from specific SQL databases in Azure. I have tested the Powershell script in Azure Cloud Shell, and it works as intended.
I want to schedule this to run automatically each day. I thought this is something that can be scheduled with 'Azure Automation', but it appears I am mistaken. It seems Automation is a tool for running scripts on resources, not in Azure CLI itself.
This seems like a simple task, but I am having trouble finding a solution. What would be the best approach to achieve this?
Thanks,
Ed
Azure Automation
{count} votes
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(275.2, 41%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAM%3C/text%3E%3C/svg%3E)
AnuragSingh-MSFT 21,546 Reputation points Moderator2022-09-26T04:30:52.02+00:00 @Ed Summ , I wanted to check if you had a chance to review the answers below. Please let me know if you have any questions.
Please 'Accept as answer' if it helped so that it can help others in the community looking for help on similar topics.
Sign in to comment
3 answers
Sort by: Most helpful
-
T. Kujala 8,761 Reputation points2022-09-20T03:45:32.013+00:00 -
Maxim Sergeev 6,586 Reputation points Microsoft Employee2022-09-20T06:43:58.077+00:00 Currently, Azure Automation Account doesn't support CLI
Sign in to comment -
-
Maxim Sergeev 6,586 Reputation points Microsoft Employee
2022-09-20T06:50:41.467+00:00 Hi there,
Just to clarify. Azure supports different options to deploy your scenario, including Azure PowerShell, Azure CLI, Azure ARM (or bicep) or direct RestAPI calls to ARM.
If you have developed a Powershell based script, you can definitely use Azure Automation Account that supports PowerShell natively. If you have developed a CLI script, it requires to be triggered where CLI is installed (sadly, Azure Automation doesn't support this today).
Can you clarify what type of script you are going to use?p.s. check the difference between Azure CLI and Powershell
https://learn.microsoft.com/en-us/cli/azure/what-is-azure-cli
https://learn.microsoft.com/en-us/azure/developer/azure-cli/choose-the-right-azure-command-line-tool-
Ed Summ 1 Reputation point
2022-09-27T04:48:10.383+00:00 Hi,
Thanks for all the above answers. It appears Azure Automation would be the best way to do this. I am just working on having the script run smoothly via Automation. Yes, the script is Powershell, utilising az.sql module. If I open the Azure Powershell Cloud Shell interface in the Azure Portal, I can run my Powershell script and it works fine. I would assume this is because I am logged into Azure, thus already authenticated. That same script falls over in Automation, as I believe it's looking for authentication.
Would I be correct in assuming the best way to do this is to put a authentication portion at the beginning of the script. eg some sort of key store or certificate based method? I am fairly new to Powershell, so apologies if I am mixing up any terminology.
Thanks
-
Maxim Sergeev 6,586 Reputation points Microsoft Employee
2022-09-27T04:55:32.95+00:00 Enable Managed Identity, grant required permissions to the identity and add the code to your powershell script running in Azure Automation
https://learn.microsoft.com/en-us/azure/automation/enable-managed-identity-for-automation
# Sign in to your Azure subscription $sub = Get-AzSubscription -ErrorAction SilentlyContinue if(-not($sub)) { Connect-AzAccount } # If you have multiple subscriptions, set the one to use # Select-AzSubscription -SubscriptionId "<SUBSCRIPTIONID>"
Sign in to comment -
-
AnuragSingh-MSFT 21,546 Reputation points Moderator
2022-09-20T07:05:02.83+00:00 Hi @Ed Summ ,
Thank you for the question. The link provided by @T. Kujala above should help you get started with Azure Automation.
In addition to the resource above, I would like to clarify the following points related to "..It seems Automation is a tool for running scripts on resources, not in Azure CLI itself."
- Azure Automation performs script execution similar to how you would execute script in cloud shell OR locally on your machine using the same Az modules. Only in Azure Automation account, there is no manual intervention required. The script is stored as a runbook and executed in a sandbox in Azure environment or on Hybrid worker. The trigger for this execution could be schedule based, based on a web api call or even manually (if required).
- The execution of these runbooks (stored script) does not happen in Azure Cloud Shell. It happens inside another sandbox. The cloud shell is provided as an end user tool to be able to execute scripts/cmds withoutt requiring local installation - and is available from everywhere.
You may also refer to the link here to get a detailed walkthrough of similar scenario to get started - https://learn.microsoft.com/en-us/answers/questions/915711/index.html
Please let us know if you have any questions.
---
Please 'Accept as answer' if it helped so that it can help others in the community looking for help on similar topics.