How to find the Job owners in a SQL server instance
use msdb go SELECT j.[name] AS 'JobName', Enabled = CASE WHEN j.Enabled = 0 THEN 'No' ELSE 'Yes' END, l.[name] AS 'OwnerName' FROM MSDB.dbo.sysjobs j INNER JOIN Master.dbo.syslogins l ON j.owner_sid = l.sid ORDER BY j.[name] GO
No comments:
Post a Comment