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