List all Jobs in the SQL Server

I needed to list all jobs that has been created in a SQL Server, with job owner, Created Date and Modified date. This query helped me.
Select a.Name as job_name,
b.name as job_owner,
[description],
Date_Created,
Date_Modified
From msdb..sysjobs a INNER JOIN sys.syslogins b on a.owner_sid = b.sid
Order by Date_Created DESC

No comments:

Post a Comment