List SQL Server Agent JOBS in SQL Server 2008/2005/2000

Wednesday, May 27, 2009 |

As a DBA we may need to set the JOB for various task and those tasks will be saved under MSDB database. You can see it from EM or from SSMS GUI tools but it would help sometime to execute query to see the list of available JOB in SQL Server 2000+ versions.
There are two ways to achieve that task. Have a look at it.

--with stored procedure

--with sysjobs view
select * from msdb..sysjobs

Both of the above statements will give you list of JOB have been set in SQL Server Agent along with so many other important details.

Reference: Ritesh Shah
Note: Microsoft Books online is a default reference of all articles but examples and explanations prepared by Ritesh Shah, founder of