Notification

[Meena Desai]

Hi,

In my site there are user postings and on certain condition I want to send
Notification to users informaing them about their postings details. I am
using SQL Server 2000. I dont want to use the Notifications Services
provided in SQL Server. Is there any other way to do the same ?

Thanks in Advance.
Meena

 

[Eliyahu Goldin]

Do you have access to an email server to send emails? It's pretty
straightforward in ASP.NET

Eliyahu

 

[Meena Desai]

Yes, I do have access to the mail server, I am using mailing services and it
is working fine, the problem is: I want to check in database once in a day
and want to send notification to the users if some condition is satisfied. I
dont want to use thread.

 

[Eliyahu Goldin]

Then write a regular (windows or console) application that will check
database and do emailing and setup a scheduled task to run the app once a
day.

You can make a more fancy solution like in

Combine Web and Windows Services to Run Your ASP.NET Code at Scheduled
Intervals
http://msdn.microsoft.com/msdnmag/issues/05/03/SchedulingASPNETCode/

Eliyahu