tag:blogger.com,1999:blog-1714283384790610704.post394805607306543816..comments2023-12-01T12:13:25.623-06:00Comments on Lane's Tech Blog: How to Change the Owner of All SQL Agent Jobs in a SQL Server InstanceLanehttp://www.blogger.com/profile/05548461086853951131noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-1714283384790610704.post-47221150322904843942015-09-08T12:51:24.239-05:002015-09-08T12:51:24.239-05:00While most people would say that editing the syste...While most people would say that editing the system tables directly is wrong, they don't know why IN THIS CASE it's a bad idea. SQL Server Agent caches job information, editing the table directly won't update the data in the cache. Updating the jobs using sp_update_job as you've written is perfect advice.K. Swizzlenoreply@blogger.comtag:blogger.com,1999:blog-1714283384790610704.post-80262064776340532422014-09-17T03:43:53.602-05:002014-09-17T03:43:53.602-05:00Thanks a ton! Thanks a ton! Anonymousnoreply@blogger.com