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 |
|
Steve2106
Posting Yak Master
183 Posts |
 Posted - 2009-01-30 : 06:54:30
|
| Hello,I have been asked to setup a procedure to send out reminder emails based on a date in one of my Tables. I do not want to do this in my .net application and was wondering if there is a way of doing it in Sql Server. So at 23:00 send out an email for all dates that are due in 5 days from todays date.Is that possible?Thanks for your help, I appreciate it.Best Regards,Steve Wilson. |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2009-01-30 : 07:00:47
|
| In SQL 2000, look at xp_sendmail. You need to set up a mail profile for the database and you will need to set up a job to run at 23:00. |
 |
|
|
Steve2106
Posting Yak Master
183 Posts |
Posted - 2009-01-30 : 07:07:23
|
| Hi,Thanks for the quick reply.Can you ellaborate on this a bit further.Thanks,Steve. |
|
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-01-30 : 09:34:54
|
| Here is detailed KB article:http://support.microsoft.com/kb/263556 |
|
|
|
|
|
|
Sending Emails