Anyone?
From: [email protected] [mailto:[email protected]] On Behalf Of Roland Janus Sent: Dienstag, 12. November 2013 13:24 To: [email protected] Subject: [mssms] Half OT: SQL query to change ownership 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%' ?
