SQLAgentJob

Fix owner login issue in Agent Job using Entra ID in SQL MI

by

When I was working on creating and scheduling an agent job, I encountered the below error message. Error Message Create failed for Job ‘GUI_Demo_Daily_Insert’. (Microsoft.SqlServer.Smo) Additional information: An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo) The specified ‘@owner_login_name’ is invalid (valid values are returned by sp_helplogins [excluding Windows NT groups]). (Microsoft SQL … Read more

How to Create and Schedule a SQL Agent Job in Azure SQL MI

by

If you are running tasks manually on your databases, it’s time to automate. SQL Agent Jobs allow us to schedule T-SQL statements against the databases in Azure SQL MI so they run on their own. Today, I’m not going to waste time talking about the theory behind it. I’m just going to show you the … Read more