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 - 2004-02-10 : 07:50:12
|
| Manav writes "I have two fields in a table, the Start_Date, and the End_Date. I want that SQL Server should automatically send an email to the manager when the End_Date is expired. The email address is also in one of the field in the table. How can I do that?I appreciate your help. Thanks," |
|
|
HendersonToo
Starting Member
20 Posts |
Posted - 2004-02-11 : 16:33:54
|
| You can utilize SQL Server Agent to run a stored proc on a daily basis. These tasks are easily scheduled through enterprise manager. See management/Sql server agent/Jobs.Writing the stored procedure to send an email is pretty easy. Do a search on sqlteam.com for some ready-to-use stored procedures.See http://www.sqlteam.com/item.asp?ItemID=5003 and http://www.sqlteam.com/item.asp?ItemID=401 for even more information. |
 |
|
|
|
|
|
Sending email from SQL Server 2000