How to get a list of SQL Jobs in SQL Server
In this article i will explain how to get list of SQL Jobs in SQL Server.
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.
CreatedJan 11, 2014
UpdatedOct 03, 2020
Different types of variables in SQL Server
What is Cross Join in SQL Server
How delete record from parent table when there is Foreign Key relation in SQL Server
What is the differences between CHAR, NCHAR, VARCHAR and NVARCHAR in SQL Server?
How to add or remove a column from a table in SQL Server?
How to insert values into Identity Column in SQL Server?
How to get a fixed-length value in SQL Server?
What is Left Join (or) Left Outer Join in SQL Server?
How to get current week dates in SQL Server?
What are the different types of Date formats in SQL Server?