Hi,
I have trouble getting the alerts to work on SQL 2005.
Below I define a custom message and a custom alert.
When I raise the error though the alert never fires.
Any ideas why that would be?
Thanks,
Patrick
-------------------------------------------------------
USE master
GO
EXEC sp_addmessage 50001, 16, N'The version of SQL Server has been
requested.'
GO
------------------------------------------------------
USE [msdb]
GO
EXEC msdb.dbo.sp_add_alert @name=N'TEST Alert',
@message_id=50001,
@severity=0,
@enabled=1,
@delay_between_responses=5,
@include_event_description_in=5,
@notification_message=N'TEST',
@category_name=N'[Uncategorized]',
@job_id=N'00000000-0000-0000-0000-000000000000'
------------------------------------------------------
RAISERROR (50001, 16, 1)
------------------------------------------------------