SQL CODE BANK
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
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment