Solved

SQL Server 2008 will not send email alerts

Posted on 2010-09-01
2
435 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

Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Sql Permission 6 44
How to generate total number of records in db 35 26
SQl query 19 14
encyps queries mssql 15 27
In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.
This tutorial demonstrates a quick way of adding group price to multiple Magento products.

760 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

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now