SELECT
'EXEC MSDB.dbo.sp_update_job ' + Char(13)
+ '@job_name = ' + Char(39) + j.[name] + Char(39)
+ ',' + Char(13) + '@owner_login_name = '
+ Char(39) + 'sa' + Char(39) + Char(13) + Char(13)
FROM
msdb.dbo.sysjobs j
INNER JOIN master.dbo.syslogins l
ON j.owner_sid = l.sid
WHERE
l.[name] <> 'sa'
ORDER BY
j.[name]
'EXEC MSDB.dbo.sp_update_job ' + Char(13)
+ '@job_name = ' + Char(39) + j.[name] + Char(39)
+ ',' + Char(13) + '@owner_login_name = '
+ Char(39) + 'sa' + Char(39) + Char(13) + Char(13)
FROM
WHERE
ORDER BY
j.[name]
Comments
Post a Comment