[mssms] Half OT: SQL query to change ownership

[Roland Janus]

Well, it is CM related.

 

I know how to update ownership of a job: 

 

EXEC msdb.dbo.sp_update_job @job_id=N'ac0ec0eb-738e-4b82-9a4c-0a6ae3fc17ed',


              @owner_login_name=N'NT SERVICE\SQLSERVERAGENT'

 

Also how to get the job

 

select * from msdb.dbo.sysjobs where name like '%mpreplic%'

 

but how do I change the owner for all jobs named e.g. '%test%' ?