venkatasatyakota wrote: i want a technique to execute a program each day 12 am You would probably be hosting your application in a shared hosting environment and in your scenario it is very rare that you would be given access to the scheduled task to run a stand alone application. Best is to talk to your hosting provider, as in the shared hosting environment they usually provide you with something called Web Scheduler(atleast my hosting provider does :-D ). This is nothing but a schedule at which a specified url is requested at certain time.:rose: Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.

If your database is SQL Server, I would create a SQL Agent job that runs on a schedule to scan the table. Then you can use database mail to send the emails. My other signature is witty and insightful.