I want to periodically check for certain values in a database attached to a
web site, and send email when such values are found. So, two questions...
1. I can write a simple query to return rows with the values... but how do
I set it up to execute automatically on a daily schedule?
2. What's the best way (or what ways are available) to automate the
creation and sending of email messages from within a SQL 7 process? At
times, I may need to send messages to one person, other times, I may have to
send similar (or customized) messages to potentially large numbers of