Press "Enter" to skip to content

Replacing SQL Agent In Azure

Bob Rubocki has some Q&A regarding automating in Azure the types of things you’d normally run SQL Agent jobs for:

Q: Is there any way to handle the execution of SSIS packages stored locally?

A: Azure Automation works on Azure resources.  It cannot be used for executing local SSIS packages.

In some cases, you may still need a scheduling tool (which might be a VM with SQL Agent).