====== MSSQL - Query Jobs with Owners ======
<code sql List jobs>
SELECT s.name AS JobName, l.name AS JobOwner
FROM msdb..sysjobs s
LEFT JOIN master.sys.syslogins l ON s.owner_sid = l.sid
WHERE l.name IS NOT NULL
ORDER by l.name
</code>
<code sql Reassign jobs>
USE msdb ;
GO
EXEC dbo.sp_manage_jobs_by_login
@action = N'REASSIGN',
@current_owner_login_name = N'sa'
@new_owner_login_name = N'QUICK\Pinal', ;
GO
</code>