MSSQLTips

MSSQLTips.com - your daily source for SQL Server tips

Welcome to MSSQLTips Sign in | Join | Help

MSSQLTips » SQL Server » SQL Server 2005 » Email notification account not visible

Email notification account not visible

Last post 06-12-2008 8:23 AM by grobido. 1 replies.

Page 1 of 1 (2 items)
	Sort Posts: Previous Next

06-12-2008 2:57 AM

arosa
Joined on 06-12-2008
Posts 1

Email notification account not visible

Reply Contact

Hi all

I set up some jobs under SQL 2005 and configured the Database Mail feature. The idea is of course to send email Alerts for certain Jobs, once they failed.

I tested the accounts I created (under "Management --- Database Mails --- right click and Send Test Mail") I received the email succesfully.

The problem is when I go to my Backup Jobs under SQL Server Agent --- Jobs -- Properties --- Notifications, I can't choose the mail account to be notified when the job for example fails.

Anyone has an idea what is missing?

Thanks for response

arosa

06-12-2008 8:23 AM In reply to

grobido
Joined on 10-11-2007
Wilton, NH
Posts 73

Re: Email notification account not visible

Reply Contact

Right click on SQL Server Agent and selet Properties.

Under Alert System enable the mail profile you setup.

Page 1 of 1 (2 items)