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.

SQL Server 2008: A message with @msgnum = 75000 and @severity = 16 was added to the SQL instance. An alert was added that is raised when error number 75000 is raised. The alert is enabled and an operator, who is also enabled, is set to be notified via email. The alert history shows that the alert is triggered, but the operator is not notified. The operator history shows "Most recent notification attempts: (Never e-mailed)".

The operator has a correct e-mail address. DBMail is setup correctly since I can sp_send_dbmail from and to that e-mail address.

Where do I begin to troubleshoot?

share|improve this question

migrated from serverfault.com Jun 29 '11 at 18:39

This question came from our site for professional system and network administrators.

1 Answer 1

You might check the on duty schedule for that particular operator. Did this alert happen while the operator was not on duty?

Is SQL Agent set to use Database Mail and a specified Mail Profile for the Alert System? (Right Click SQL Server Agent > Properties > Alert System)

These are two things that I can immediately think of that could cause this behavior.

Hope this can help.

share|improve this answer
    
My assumption would be the on duty issue. –  mrdenny Jun 30 '11 at 21:04

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.