• Such complexity to handle something built-in and simple to configure? I concur... use alerts instead!

    USE [msdb]

    GO

    --create "Operator" with customer's email

    EXEC msdb.dbo.sp_add_operator @name=N'AppSupport',

    @enabled=1,

    @email_address=N'customer@emailthem.com',

    @category_name=N'[Uncategorized]'

    GO

    --create deadlock alert

    EXEC msdb.dbo.sp_add_alert @name=N'DeadLocks',

    @message_id=0,

    @severity=0,

    @enabled=1,

    @delay_between_responses=5,

    @include_event_description_in=1,

    @notification_message=N'SQL Server deadlock alert.',

    @category_name=N'[Uncategorized]',

    @performance_condition=N'SQLServer:Locks|Number of Deadlocks/sec|_Total|>|0',

    @job_id=N'00000000-0000-0000-0000-000000000000'

    GO

    Columbus, GA SQL Server User Group
    http://columbusga.sqlpass.org/