I was busy during last few months and can not spare time for my blog. However during my project i came up with a situation that I have to send emails on daily basis through system. I would like to share the different approaches which I found during my goggling.
I came across three options to accomplish this:-
1- Create a simple .exe file which sends the mails and add it in windows scheduled tasks.
How To Schedule Task in Windows XP
2- Create a Window Service, which sleeps for 24 hours after sending emails.
Simple Windows Service Sample
3- Create a JOB in Sql Server. For details see:
Automated Email Notifications using SQL Server Job Scheduler