Find out who are the owners of the SQL Server agent jobs with the help of below script.
SELECT
J.name AS [Job Name]
,L.name AS [Job Owner]
FROM
msdb.dbo.sysjobs_view J
INNER JOIN master.dbo.syslogins L
ON J.owner_sid = L.sid
GO
Job Name | Job Owner |
DatabaseBackup – USER_DATABASES – DIFF | sa |
sp_delete_backuphistory | sa |
syspolicy_purge_history | sa |
DatabaseBackup – USER_DATABASES – FULL | sa |
sp_purge_jobhistory | sa |
CommandLog Cleanup | sa |
DatabaseBackup – SYSTEM_DATABASES – FULL | sa |