Hi All,
I need some help in configure our SQL 2K & 2K5 servers to send notification on job failers. Have created operators on SQL 2k but when i try to do a test mail it fails saying mai session is not running. I go to properties of the Sql agent to turn on mail session but it is grayed out. Can someone please direct me to the steps I need to take when setting up sql server with email capability. Do I have to install office (outlook on the sql server box) in order for emailing to work?
Thanks in advance for your help.
Nats
On SQL 2000 servers, you will need a MAPI client installed (e.g., Outlook).
However, I recommend checking out the usage of xp_smtp_sendmail -an alternative to installing Outlook and all of its issues.
Mail –Sending
SQL 2000 - http://www.sqldev.net/xp/xpsmtp.htm
http://www.aspfaq.com/show.asp?id=2403
No comments:
Post a Comment