Schedule an email based on date in SQL DB

[msnews.microsoft.com]

Hi,

Can you schedule emails/events based on SQL data?

Example:
User sets an expiration date via web form to SQL DB.
When this date arrives, send out an email to the user via web form.

Any suggestions would be appreciated.

Thanks,
Roland

[Cowboy (Gregory A. Beamer) - MVP]

Set up a job in SQL Server and use SQL Mail to send the expiration email.
That is one option.

Set up a windows service that checks data once a day and does the same. That
is another option.
---

Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

***************************
Think Outside the Box!
***************************

"msnews.microsoft.com" wrote:

Hi,

Can you schedule emails/events based on SQL data?

Example:
User sets an expiration date via web form to SQL DB.
When this date arrives, send out an email to the user via web form.

Any suggestions would be appreciated.

Thanks,
Roland