Using Azure Automation to Shut Down a VM only if a SQL Agent Job is Not Running.
I have a client who uses MDS (Master Data Services) and SSIS (Integration Services) in an Azure VM. Since we only need to execute the SQL Agent job that runs the SSIS packages infrequently, we shut down the VM when it is not in use in order to save costs. We wanted to make sure… Continue reading Using Azure Automation to Shut Down a VM only if a SQL Agent Job is Not Running.