Email Notification - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Administration

Email Notification

Author

Topic

csaha
Yak Posting Veteran

52 Posts

Posted - 2010-12-16 : 17:21:08

I have setup the maintenance job to backup the database, I have also added the step in http://www.howtogeek.com/howto/database/sending-automated-job-email-notifications-in-sql-server-with-smtp/ to notify the user I have also setup the database mail using the following link http://www.kodyaz.com/articles/sql2005-database-mail.aspx and also used this link to verify everything, but I still do not get the email of the backup job. Any thoughts on this?

the_amol
Starting Member

6 Posts

Posted - 2010-12-17 : 03:41:30

Is the mail server is your local mail server and make sure it don't have Authentication enabled on it. as in this case you have to enter a username/password to authenticate at mail server.
Hope this help.

Thanks & Regards
Amol Verma
http://cybertechhawks.wordpress.com

jeffw8713
Aged Yak Warrior

819 Posts

Posted - 2010-12-17 : 13:19:48

Right-click on Database Mail and view the log. This should tell you why the messages cannot be sent.

Jeff

jeffw8713
Aged Yak Warrior

819 Posts

Posted - 2010-12-17 : 13:23:29

Looks like you are using a custom stored procedure to send emails? Is this on SQL Server 2000 or 2005/2008?

I assumed 2005 or greater - which has database mail, which is what you stated you setup and created. If so, then you don't need that custom procedure in your maintenance plans. You can just add a Notify Operator task in the sub-plan and send the notification that way.

Jeff

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources