?
Solved

SQL Server 2008 will not send email alerts

Posted on 2010-09-01
2
Medium Priority
?
443 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 8

Accepted Solution

by:
dba2dba earned 1500 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

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

I have written a PowerShell script to "walk" the security structure of each SQL instance to find:         Each Login (Windows or SQL)             * Its Server Roles             * Every database to which the login is mapped             * The associated "Database User" for this …
Hi all, It is important and often overlooked to understand “Database properties”. Often we see questions about "log files" or "where is the database" and one of the easiest ways to get general information about your database is to use “Database p…
NetCrunch network monitor is a highly extensive platform for network monitoring and alert generation. In this video you'll see a live demo of NetCrunch with most notable features explained in a walk-through manner. You'll also get to know the philos…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…

762 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