sp_helpoperator SQL Executive Stored Procedure

Reports information about the operators defined for the server.

Syntax

sp_helpoperator [having_name_like]

where

having_name_like

Is the string used to search for similar operator names. Wildcard characters are supported.

Remarks

This stored procedure must be run from the msdb database.

SQL Enterprise Manager provides an easy, graphical way to manage the entire alerting system. Using SQL Enterprise Manager is the recommended way to configure your alert infrastructure.

Example

This example reports information about all operators with two names, beginning with John.

sp_helpoperator 'John%'

Permission

Only the system administrator can use this procedure.

Tables Used

sysoperators

See Also