Search

Tuesday, July 26, 2011

Script to check the owner of all jobs in sql server

USE msdb;

SELECT
A.Name AS JobName,
B.name AS JobOwner
FROM dbo.sysjobs A
INNER JOIN master.sys.syslogins B ON
A.owner_sid = B.sid;

No comments:

Post a Comment