Change SQL Server Agent Job Owner

To find owners of the jobs in SQL Server use this query:

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

You can change SQL Server Agent Job Owner using sp_update_job:

EXEC MSDB.dbo.sp_update_job
@job_name = 'Job_Name',
@owner_login_name = 'sa'

...or in SQL Server Management Studio, right click on SQL Server Agent job, and select Properties:

and change the owner.

If the post helped you, please share it:
Pin It

1 comment to Change SQL Server Agent Job Owner

Leave a Reply

You can use these HTML tags

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code class="" title="" data-url=""> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong> <pre class="" title="" data-url=""> <span class="" title="" data-url="">