list-job-category-information.md

title	description	author	ms.author	ms.date	ms.service	ms.subservice	ms.topic	monikerRange
List Job Category Information	List Job Category Information	markingmyname	maghan	01/19/2017	sql	ssms	how-to	= azuresqldb-mi-current || >= sql-server-2016

List Job Category Information

[!INCLUDE SQL Server SQL MI]

Important

On Azure SQL Managed Instance, most, but not all SQL Server Agent features are currently supported. See Azure SQL Managed Instance T-SQL differences from SQL Server for details.

This topic describes how to list job category information in [!INCLUDEssnoversion] by using [!INCLUDEtsql] or SQL Server Management Objects.

• Before you begin:

  Security

• To list job category information, using:

  Transact-SQL

  SQL Server Management Objects

Before You Begin

Security

For detailed information, see Implement SQL Server Agent Security.

Using Transact-SQL

To list job category information

1. In Object Explorer, connect to an instance of [!INCLUDEssDE].

2. On the Standard bar, click New Query.

3. Copy and paste the following example into the query window and click Execute.

   -- returns information about jobs that are administered locally  
   USE msdb ;  
   GO  
   
   EXEC dbo.sp_help_category  
       @type = N'LOCAL' ;  
   GO  
   

For more information, see sp_help_category (Transact-SQL).

Using SQL Server Management Objects

To list job category information

Use the JobCategory class by using a programming language that you choose, such as Visual Basic, Visual C#, or PowerShell.