Provides information about the specified classes of jobs, alerts, or operators.
sp_help_category [[@class =] 'class']
[,[@type =] 'type']
[,[@name =] 'name']
[,[@suffix =] suffix]
Value | Description |
---|---|
JOB | Provides information about a job category. |
ALERT | Provides information about an alert category. |
OPERATOR | Provides information about an operator category. |
Value | Description |
---|---|
LOCAL | Local job category. |
MULTI -SERVER | Multiserver job category. |
NONE | Category for a class other than JOB. |
0 (success) or 1 (failure)
Column name | Data type | Description |
---|---|---|
category_id | int | Category ID |
category_type | tinyint | Type of category: 1 = Local 2 = Multiserver 3 = None |
name | sysname | Category name |
sp_help_category must be executed in the msdb database.
If no parameters are specified, the result set provides information about all of the job categories.
Execute permissions default to the public role. Anyone who can execute this procedure can also create, delete, or update a job, job step, job category, job schedule, job server, task, or job history information.
This example returns information about jobs that are administered locally.
USE msdb
EXEC sp_help_category @type = 'LOCAL'
This example returns information about the Replication alert category.
USE msdb
EXEC sp_help_category @class = 'ALERT', @name = 'Replication'
sp_add_category | sp_update_category |
sp_delete_category | System Stored Procedures |