SQL Server: Get List of SQL Jobs

 SQL Server     sbo     Updated on Jan 11, 2014     VIKRAM     589   

Introduction:

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

Description:

In previous articles i explained about joinsBatchesStored procedureFunctionsDifference between Stored procedure and FunctionTriggers 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.

  Related Articles
  Recent Articles