How to get a list of SQL Jobs in SQL Server

Introduction:

In this article i will explain how to get list of SQL Jobs in SQL Server.

Description:

In previous articles i explained about joins, Batches, Stored procedure, Functions, Difference between Stored procedure and Function, Triggers and How to get list of stored procedures with Created Date and Modified Date in SQL Server. Now i will explain how to get list of SQL Jobs in SQL Server.

We can get list of SQL Jobs by using following query:

use msdb
select        j.[name] as [Job Name],
            (case when j.[enabled] = 0 then 'Disabled' else 'Enabled' end) as [Job Status],
            j.[description] as [Job Description],
            j.date_created as [Created Date],
            j.date_modified as [Modified Date]
from        sysjobs j
order by    j.name

Once if we run the above query we will get all the SQL Jobs with Name, Status, Description, Create Date, Modified Date.