sp_helpalert SQL Executive Stored Procedure

Reports information about the alerts defined for the server.

Syntax

sp_helpalert [having_name_like]

where

having_name_like

Is the string used to search for similar alert_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 alerts with a name beginning with Test.

sp_helpalert 'Test%'

Permission

Only the system administrator can use this procedure.

Tables Used

sysalerts, systasks

See Also