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 |
|
saidev
Posting Yak Master
101 Posts |
 Posted - 2010-07-29 : 02:01:57
|
| Hi guys,Basically i want to check the Date field in the sql table with Current date. If it is greater than 5 days then i want to send E-mail to 1 person. is it possible to create a schedled task in DTS(i am using sql server2000) to run every day at night? if so can i check this condition in stored procedure and assign that stored procedure to scheduler? Please advise.I am using VS2003/VB.NET/ASP.NET/SQL Server 2000Thanks. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
saidev
Posting Yak Master
101 Posts |
Posted - 2010-08-08 : 03:03:31
|
quote:
Originally posted by saidev
Hi guys,Basically i want to check the Date field in the sql table with Current date. If it is greater than 5 days then i want to send E-mail to 1 person. is it possible to create a schedled task in DTS(i am using sql server2000) to run every day at night? if so can i check this condition in stored procedure and assign that stored procedure to scheduler? Please advise.I am using VS2003/VB.NET/ASP.NET/SQL Server 2000Thanks.
Hi,I can schedule the DTS in sql server2000, but i don't want to send the E-mail every day. I just want to send based on the date in sql table. Can you suggest with some examples?Thx |
 |
|
|
|
|
|
Sending Automatic E-mails