How to change the SQL Agent Job Owner | SQL Sever DBA Tips and Tricks
Have you ever had a SQL Server Agent job owned by a user. When that user leaves or the login gets removed the job stops working? Well this video will show you how to identify the owner of a job and "create script to Create" a script that will let you change the owner of several jobs on the same SQL Server Instacne
You can check out the blog post here:
http://www.gethynellis.com/2018/03/id...