Technical Article

Know the JOBNAME and JOBOWNER

,

As an administrator it is required sometimes to list out the job owners.This is a simple script that will allow to fetch this information. By applying a filter a specific job owner list can be fetched.

select JOBNAME = a.name, JOBOWNER = b.name
from msdb..sysjobs a
inner join master..syslogins b on (a.owner_sid = b.sid)

Rate

5 (1)

You rated this post out of 5. Change rating

Share

Share

Rate

5 (1)

You rated this post out of 5. Change rating