SQL Server 2008 will not send email alerts
Posted on 2010-09-01
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.