Elastic Database Jobs: Sample for Running T-SQL Code in Multiple Databases

Introduction: After moving from on-premise SQL Server to Azure SQL Database, the SQL Server Agent service is no longer available to you. Administrators are therefore missing the ability to run recurring jobs, in order to execute T-SQL scripts and Stored Procedures on a schedule. Elastic Database Jobs are one way of implementing a scheduled execution on…


Lesson Learned #2: Do you need SQL Server Agent for Azure SQL DB?

Many questions came to us, about SQL Server Agent for Azure SQL DB. Unfortunately, we don’t have the SQL Agent service in the same way that you have in OnPremise, but we have a multiple solutions for it: If you are able to maintain the SQL Agent, you could create a linked server against to…