continously running thread in asp.net web application

i want a continously running thread in my web application for sending mail to admin if th开发者_运维百科e logged complaint of the user in not solved by technician within 24 hours.

i am able to send mail to administrator

i just want a watch on database for unsolved issues with timespan of more than 24 hours and inform to administrator about the same

how can i perform it. any ideas

Create an aspx page/asmx service to check the database and send email providing appropriate check in the page/service. This page/service can then be called using PowerShell script on the server, and that powershell script can be scheduled to run in task schedular using specified intervals. Hope this shall acheive what you wants.

The right way to do it would be to write a Windows Service which will monitor the database and send emails out.

If your asp.net web application uses sql server, which i imagine it does, i would reccomend creating a sql agent job which executes some sql with the business logic you desire, and sends emails using the built in sql server email sending functionality

SQL Server Agent Mail

1) Windows service which will monitor the table

2) SQL Job