Script to Check List of SQL Jobs, their Status and owner

Problem:   SQL Script to get list of SQL Jobs running under SQL Agent, their Status and Job Owner Details

 

Solution:   Below is the script.

 

SQL Script:

_______________________________________

USE msdb

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

_______________________________________

 

ScreenShot:

 

Advertisements

Posted by Siddharth Verma on November 15, 2016

https://exploresqlserver.wordpress.com/2016/11/15/script-to-check-list-of-sql-jobs-their-status-and-owner/