SP_CreateAndEnableFailureAlerts

Stored procedure for creating and enabling operator alerts

Create this in your management DB to create, assign and manage the alerts for SQL serverv agent