Categories
SQL Server

SQL SERVER – Retrieve Information of SQL Server Agent Jobs

sp_help_job returns information about jobs that are used by SQLServerAgent service to perform automated activities in SQL Server.

EXEC MSDB.DBO.SP_HELP_JOB

Related posts:

  1. How To Obtain a List of DTS Packages exec msdb..sp_enum_dtspackages...
  2. SQL SERVER – 2005 – List all the database List all the database on SQL Servers. SQL SERVER 2005...