Evaluate and fix job owners

evaluate-jobowner.sql

SELECT
	J1.[name] AS job_name
,	C1.[name] AS category_name, S1.[name] as [owner_name]
,	CASE
	WHEN S1.[name] = N'sa' OR S1.[name] LIKE '##%'
	THEN NULL
	ELSE	'EXEC msdb..sp_update_job @job_name = ''' + J1.[name] + ''''
		+	', @owner_login_name = ''sa'' -- was ' + QUOTENAME(S1.[name])
	END	AS alter_command
FROM	msdb.dbo.sysjobs AS J1
JOIN	msdb.dbo.syscategories AS C1
  ON	J1.category_id = C1.category_id
LEFT
JOIN	sys.server_principals S1
  ON	J1.owner_sid = S1.[sid]
WHERE	C1.[name] NOT IN ('Report Server')
--  AND	S1.[name] NOT IN ('sa')