Schedule an email based on date in SQL DB

  • Thread starter Thread starter msnews.microsoft.com
  • Start date Start date
M

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
 
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!
***************************
 
Back
Top