블로그 "공감"

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