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.
| Author |
Topic |
|
reddymade
Posting Yak Master
165 Posts |
 Posted - 2006-04-21 : 15:37:16
|
| I am trying to use a pop3 and smtp acccount, with the sql server agents job which does only sendmail every 5 minutes.i was using an accout which belongs to the msexchange server and it works fine. with out any problem.Now i tried to use the pop3 and smtp account which and with that it does'nt work at all. this is a third party pop3 account. i tested it through ms outlookk it sends and recieves the emails fine without any problem, but via SQL server agents job it seems to be failing. and also i went to the application log viewer i do see a warning error message created saying the sendmail job failed..Are there any issues using the pop3 acct. with a sql server send mail profile.Please Help.Thank you very much for the incormation. |
|
|
Krankensteins
Starting Member
24 Posts |
Posted - 2006-04-22 : 02:42:50
|
| It works only on Outlook 2000. In Outlook when configure maill acount then choise Exchange with internet mail. I didn't remember exat caption but it is in Outlook configuration wizard in first window wil be three choises( posibly: Exchange, Exchange with internet mail, internet mail) then you need choise choise middlest. I' found it expermentaly. |
 |
|
|
igorblackbelt
Constraint Violating Yak Guru
407 Posts |
Posted - 2006-04-26 : 11:39:52
|
| Not sure if that's an option, if this is in a dts, you can have an ActiveX that sends email using the smto server, bipassing sqlmail, talking directly with the smtp server. I'll find the code and post it to you.---Thanks!Igor. |
|
|
|
|
|
|
sql server agent job sendmail using POP3