You could write a separate small application that checks for key dates and sends out an email if the key date has been reached (or is approaching), then flag when that particular alert has been sent. Then you can set up a scheduled task via control panel to run that application every minute, hour, day, week, whatever suits.
That would be the simplest solution if the trigger wasn't time-critical to the minute and you have direct access to the web server settings.
Main Topics
Browse All Topics





by: pivarPosted on 2009-03-15 at 14:24:13ID: 23893230
Hi,
e.com/Micr osoft/Deve lopment/MS -SQL- Serve r/SQL-Serv er-2005/Q_ 23519607.h tml
en-us/libr ary/ms1902 68.aspx en-us/libr ary/ms1914 39.aspx
If you have the data in sql server you could schedule a job that uses sp_send_dbmail to send email.
Here's a link to an example of writing the sql code:
http://www.experts-exchang
Here are links on howto create and schedule a job:
http://msdn.microsoft.com/
http://msdn.microsoft.com/
/peter