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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-08-18 : 07:28:57
|
| Ken writes "We are trying to execute a job in the sql server, but we faced some problems. The job I created is to automatically send email to the receipients everyday. But the IIS is not installed inside the server which hosts the sql server, thus we cannot get the email to be sent. When we tried to execute the job, we will get an error “The object sendMail is invalid” This error occurs because there is no SMTP server(Included when we installed IIS) included in the comp. Can we work around it?" |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2003-08-18 : 07:35:41
|
So basically you are asking how to send SMTP email without an SMTP server. Can't do it  Are you using the SMTP method as described in the article on this site ? If so, the SMTP can be on a different server though, just specify the other server.Damian |
 |
|
|
|
|
|
Sending Email @Sql Server