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 |
|
Juls
Yak Posting Veteran
51 Posts |
 Posted - 2002-03-15 : 10:48:48
|
| Hi, I need some direction.This is what I need to do:If certain criteria in a record in one of my table is met (like a date passed) I want an email to automatically go out with some text that I specify to a person with an email address in another table in my DB.For example, if an event happened (listed in tblEvents) I need an email go out the next day to a host of this event (listed in tblHosts).From what I read it looks like I will have to set up a job and use VBScript to send email. Am I right? Did someone do something like this before and can help me?Thanks so much,Juls |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2002-03-15 : 11:05:02
|
| look in the articles or FAQ or search for Mail Queue. There's some threads there that should help you. |
 |
|
|
|
|
|
Auto email when criteria is met