[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 451
  • Last Modified:

SQL Server 2008 will not send email alerts

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
kckip
Asked:
kckip
1 Solution
 
dba2dbaCommented:
You have to restart SQL Agent  after enabling mail profile.
0
 
wolfman007Commented:
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

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now