Sets all agent jobs owner to sa account

Set-AgentJobOwnerToSA

SELECT 'EXEC msdb.dbo.sp_update_job @job_id=N''' + CAST(j.job_id AS VARCHAR(150)) + ''', @owner_login_name=N''sa'' '
FROM msdb.dbo.sysjobs AS j
    INNER JOIN master.sys.syslogins AS L
        ON j.owner_sid = L.sid
    INNER JOIN msdb.dbo.syscategories AS C
        ON C.category_id = j.category_id
WHERE msdb.dbo.SQLAGENT_SUSER_SNAME(j.owner_sid) <> 'sa';