Mail reminders and alerts.
-
Hi all, I am making one web application using ASP.NET and VB.NET 2.0. I want to make alerts and reminders for this application. User can set reminder for some specific date and they get mail as a reminder on that. Plus one day every week system check for users if they fill one form or not. If not then they will get mail to alert it. Can I know how I can do this? I am using SQL Server 2000 as a database. Thanks in advance, Priyank
-
Hi all, I am making one web application using ASP.NET and VB.NET 2.0. I want to make alerts and reminders for this application. User can set reminder for some specific date and they get mail as a reminder on that. Plus one day every week system check for users if they fill one form or not. If not then they will get mail to alert it. Can I know how I can do this? I am using SQL Server 2000 as a database. Thanks in advance, Priyank
Hi, I think that you can use two solutions. First, you can create windows service which will do something automatically. In another way, you can create simple tool which will send e-mails and configure Windows "Schedule Task" to run it. You can send e-mails using .NET Framework. But you also can create stored procedure for SQL Server fo e-mail sending. How to do this see here. If you will do this using SQL Server only, you can run this stired procedure using osql.exe in BAT-files.