SpruceNE
January 11th, 2006, 10:39 AM
I am using windows 2000 OS that has cdosys.dll. Right now I need add some notification emails after MSSQL server job steps without setup SQL Mail. The environment I am using now, no outlook, no profile, no exchange server. The only email server is Lotus Notes.
I did use the method below. It worked fine when in the MS exchange environment.
http://www.orcsweb.com/articles/sendmailsql.aspx
http://support.microsoft.com/default.aspx?scid=kb;en-us;312839&sd=tech
But now, if I setup my local SMTP server, and point cdo method smtpserver to it. All my emails can send to the Inetpub\mailroot\queue. But just stay there. Some thing must be wrong here. Could anyone give me some suggestions?
Thanks,
I did use the method below. It worked fine when in the MS exchange environment.
http://www.orcsweb.com/articles/sendmailsql.aspx
http://support.microsoft.com/default.aspx?scid=kb;en-us;312839&sd=tech
But now, if I setup my local SMTP server, and point cdo method smtpserver to it. All my emails can send to the Inetpub\mailroot\queue. But just stay there. Some thing must be wrong here. Could anyone give me some suggestions?
Thanks,