Introduction
SQL Server Agent enables the ease of scheduling routine tasks without leaving the comfort zone of SQL Server Management Studio (SSMS). This system stores all its related data in the msdb database. This article is going to discuss the need for more features in SQL Server Agent, essentially making the case for a SQL Server Agent 2.0.
Problem
I know everything nowadays is about Azure, but let’s not forget that a big chunk of SQL Server clients (on-premise, SQL Azure Managed Instance, Azure VM) are not ready or just can’t migrate to a contained SQL database product. There is