SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Old Forums
 CLOSED - General SQL Server
 sql agent mail
 Forum Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

-Dman100-
Posting Yak Master

210 Posts

Posted - 03/19/2006 :  00:56:14  Show Profile
I'd like to setup sql agent mail to provide me auto notifications if any problems arise during backups in my development environment. I have a home LAN with my work station PC and a Proliant server running Windows 2000 Server and SQL Server 2000.

I tried unsuccessfully to setup SQL Agent Mail. So, first, I'm trying to determine the best option or which options I have available to setup SQL Agent Mail.

I have internet email through my ISP and I also setup IIS to process CDO scripts for testing purposes in apps that I'm developing. I wasn't sure if this was an option to use with SQL Agent Mail? Or, if I can only use internet email? I understand using Exchange is another option, but I don't have MS Exchange.

I read that using Internet email could cause possible problems by putting SQL Server in single user mode or possibly stopping SQL Server?

If anyone could offer any information and recommendations on the best option and method to setup SQL Agent Mail, it would be greatly appreciated.

Thank you.
Regards,
-D-
  Previous Topic Topic Next Topic  
 Forum Locked
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000