How to Change the Owner of All SQL Agent Jobs in a SQL Server Instance

Each job in a SQL Server instance has an owner, and you may run into a situation in which that owner needs to be changed.
If there are a lot of jobs that were created by that owner, this can be a tedious task.
Here we’re opening a cursor and looping through the SQL Agent Jobs in the instance that are owned by the old user (@olduser) and executing the sp_update_job stored procedure to change that to match @newuser.

USE MSDB
GO
declare @jobname varchar (200)
declare @oldusername varchar (30)
declare @newusername varchar(30)
set @oldusername=’DOMAIN\oldusername’
set @newusername=’DOMAIN\newusername’
declare cur_jobname cursor LOCAL
for select name from sysjobs
where suser_sname(sysjobs.owner_sid) =@oldusername
open cur_jobname
fetch next from cur_jobname
into @jobname
While @@FETCH_STATUS = 0
begin
EXEC msdb.dbo.sp_update_job @job_name=@jobname,
@owner_login_name=@newusername
fetch next from cur_jobname
into @jobname
end
close cur_jobname
deallocate cur_jobname