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.

 All Forums
 Old Forums
 CLOSED - General SQL Server
 Auto email when criteria is met

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.


Go to Top of Page
   

- Advertisement -