Wednesday, March 21, 2012

Job notification status on sql server 8

I wanted to send notification to several users regarding the job status on sql server whether it was successful or failed. I am using windows 2003 server and our domain is operating on webmail which is not a microsft product. I am a newbie so if anyone could help me out on what procedures should I take to make this work.

Any help would be very much appreciated.

As long as your mail server is using smtp, you should only have to specify the proper smtp service and port name in the setup. What version of SQL2005 are you using? I'm using Standard Edition and SqlExpress Advanced Tools on subscriber's stations. We have a mail smtp server, and that's all I had to do.

Do you have database mail enabled and configured?

Check this link: http://msdn2.microsoft.com/en-us/library/ms191442.aspx

and this one, which has a link to a demo tutorial on setting database mail up.

http://www.microsoft.com/technet/community/events/sql2005/sql-01.mspx

Good luck, and let us know how it turns out.

No comments:

Post a Comment