Solved

SQL Server 2008 will not send email alerts

Posted on 2010-09-01
2
439 Views
Last Modified: 2012-05-10
I am new to SQL. I am trying to setup alerts to email me when a job fails. I have setup a database mail profile, and sent a test message, which works fine. I then setup the SQL Agent to enable mail profile under 'Alert System'. I then setup alerts for errors of severity of  17 or higher. I then ran a backup job I knew would fail because of insufficient disk space, when it failed, I am not getting a message. I have to be missing something here, just do not know what.

Additional information:  I run the SQL Agent service under its own domain user account. This account is a standard domain account that does not have admin rights to anything. I did create a login for this account in the msdb database, and added it to the DatabaseMailUserRole.

I am getting fustrated and am running out of ideas here.
0
Comment
Question by:kckip
2 Comments
 
LVL 8

Accepted Solution

by:
dba2dba earned 500 total points
ID: 33579371
You have to restart SQL Agent  after enabling mail profile.
0
 
LVL 14

Expert Comment

by:wolfman007
ID: 33594697
Right click on SQL Server Agent, and select properties, then Alert System.

Have you checked the box to enable mail profile and specified the Mail System, and the Mail Profile to be used for Alerts?

Your Mail System should be Database Mail, and the Mail Profile should be the name of the profile you created inside Database Mail.
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

After restoring a Microsoft SQL Server database (.bak) from backup or attaching .mdf file, you may run into "Error '15023' User or role already exists in the current database" when you use the "User Mapping" SQL Management Studio functionality to al…
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

830 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question