SQL SERVER – Retrieve Information of SQL Server Agent Jobs | Journey to SQL Authority with Pinal Dave

sp_help_job returns information about jobs that are used by SQLServerAgent service to perform automated activities in SQL Server. When executed sp_help_job procedure with no parameters to return the information for all of the jobs currently defined in the msdb database. EXEC MSDB.DBO.sp_HELP_JOB Reference : Pinal Dave (http://blog.SQLAuthority.com) , BOL Continue Reading...

Source: SQL SERVER – Retrieve Information of SQL Server Agent Jobs | Journey to SQL Authority with Pinal Dave