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 - 2001-01-25 : 12:01:02
|
Prakash writes "Hi SQLGURU,
This is my requirement.
Using SQL Mail and Scheduling i wanna escalate mails to the
list of email id which has to be fetched from the database.
Depending on the status of the condition, the mail should
automatically go to the respective email-ids.
Example:
Suppose in the manufacturing domain. If a sales Engineer books
an order from delhi, a person from his division has to approve
the order so that indending, invoicing and despatch can happen.
Now the system has the product division head's email id in the
database. Now the system will check the date of order raised and
the current date. If the difference is more than 5 days the
system has to send a mail to the product divsion head
automatically. This check has to be made to all the orders raised. And the check should be made every day.
I have plans to accomplish this task using SQL mailing being
scheduleded. Will this work. OR give me better solution as
earlier as possible.
regards
Prakash" |
|
|
|
|
|
Regarding SQL Mailing