Job 소유주 변경 (Change Job Owner)

declare @jobName nvarchar(255)

 

declare curJobs cursor fast_forward for

                  select name from dbo.sysjobs where owner_sid = suser_sid('old_account', 0) order by name

 

open curJobs

 

fetch next from curJobs

                  into @jobName

 

while @@FETCH_STATUS = 0

begin

                  EXEC msdb.dbo.sp_update_job @job_name=@jobName, @owner_login_name='new_account'

 

                  fetch next from curJobs

                                   into @jobName  

end

close curJobs

deallocate curJobs