Azure Automation- Scheduling Stored Procedures

As database administrators, we are always looking for ways to automate our daily processes.  SQL Server Agent has always been a great tool for doing this, whether it be for scheduling regular maintenance or administrative jobs.  For those of you making the leap to the PaaS offering of Azure SQL databases, you will quickly discover that SQL Server Agent is no longer a feature.  For those of you who might start to panic thinking you will now be required to wake up at 2:00 AM to manually run your weekly maintenance or nightly administrative job- don’t worry! This is where Azure Automation comes to save the day!  Azure Automation brings a PowerShell workflow execution service to the Azure platform that allows one to automate those maintenance and administrative tasks all within the Azure portal and take the role of the SQL Server Agent.  To demonstrate how you can leverage Azure Automation, I will take a common request that I have encountered with many clients who have the need to schedule a stored procedure execution.

Continue reading Azure Automation- Scheduling Stored Procedures