Whilst troubleshooting an issue with backups, I wanted to check the owner of all Maintenance Plans.
I found the following query that does just that:
SELECT sj.name AS JobName, CASE WHEN sj.[Enabled] = 1 THEN 'Yes' ELSE 'No' END AS JobIsEnabled, sl.name AS OwnerName FROM msdb.dbo.sysjobs AS sj INNER JOIN master.dbo.syslogins AS sl ON sj.owner_sid = sl.sid ORDER BY JobName