Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

For every system Alert defined to send an email, we receive a 2 alerts with the following bodies. How do I stop the message with the empty (None) description?

Empty Alert

SQL Server Alert System: 'Severity 010' occurred on \my-server

DATE/TIME: 1/30/2013 10:22:59 AM

DESCRIPTION: (None)

COMMENT: (None)

JOB RUN: (None)

Valid Alert

SQL Server Alert System: 'Severity 010' occurred on \my-server

DATE/TIME: 1/30/2013 10:22:59 AM

DESCRIPTION: Log was backed up. Database: [mydatabase], creation date(time): 2011/10/03(17:20:11), first LSN: 859915:34267:1, last LSN: 859915:192686:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'\\my-backup-server.domain.local\sqldump\my-server\mydatabase\LOG\my-server_mydatabase_LOG_20130130_114000.trn'}). This is an informational message only. No user action is required.

COMMENT: (None)

JOB RUN: (None)

Here is our definition for the "Severity 10" Alert.

EXECUTE msdb..sp_add_alert @name = N'Severity 010'
  , @message_id = 0
  , @severity = 10
  , @enabled = 1
  , @delay_between_responses = 60
  , @notification_message = NULL
  , @include_event_description_in = 1
  , @database_name = N''
  , @event_description_keyword = N''
  , @job_name = NULL
  , @performance_condition = NULL
  , @wmi_namespace = N''
  , @wmi_query = N''
GO
EXECUTE msdb..sp_add_notification N'Severity 010', N'Project Support', 7
GO
share|improve this question

closed as too localized by Jack Douglas Apr 16 '13 at 15:12

This question is unlikely to help any future visitors; it is only relevant to a small geographic area, a specific moment in time, or an extraordinarily narrow situation that is not generally applicable to the worldwide audience of the internet. For help making this question more broadly applicable, visit the help center.If this question can be reworded to fit the rules in the help center, please edit the question.

    
If you set up (or have) an alert for something else, say level 16 errors, does the same behaviour occur? Or is it just this one alert? –  Jon Seigel Jan 30 '13 at 18:07
    
Seems to occur on all alerts. At least those that were setup with a similar script. –  BrandonMoser Feb 1 '13 at 23:57
add comment

1 Answer

By recompiling/committing the Alert, the double emails have stopped. It must have been a bad commit initially.

share|improve this answer
    
Thanks a lot for posting your solution Brandon. It looks pretty specific to your setup, so I think it'd be best to close the post 'Too Localized' but don't take that as a sleight! –  Jack Douglas Apr 16 '13 at 15:12
add comment

Not the answer you're looking for? Browse other questions tagged or ask your own question.