How to send mail after a fixed time period (timer function)

Question

User1052662409 posted

Hi all,

        Actually I want to send mail,on a fixed time interval.

       Suppose on 1st date of every month a mail should goes automatically to someone.

       Can you please help me out.

Thanks

Answer 1

User826222609 posted

There is two solutions for that

1) Create windows service in that service check the time and date if found your setting time and date then send your required email

2) Create SSIS Package

      => In package create email sending package

      => Deploye this package in sql server -> SQL Server Agent

      => Schedule this package for specific time

      When the specific time is accure then SSIS Package is execute and SSIS Package is send the email

      for SSIS Package refere the link

     http://msdn.microsoft.com/en-us/sqlserver/bb671393.aspx

     http://msdn.microsoft.com/en-us/library/ms141711.aspx

     http://www.sql-server-performance.com/articles/biz/Scheduling_a_SSIS_Package_in_SQL_Server_Agent_p3.aspx

if suitable answer then click on Answer

Answer 2

User1414178881 posted

Create a windows service that checks regularly(i.e.once a month or depending on that fixed time interval ),and send emails automatically.

Personally,I use that approach since I develop websites/webapplications for newsletter,SMS,..etc and may use SQLServer or Oracle.SSIS is for SQLServer,if you used oracle or any other DB then you have to use windows service.

Answer 3

User1052662409 posted

But I am sending mail through my C# code...

how to define conditions, for timer function (this is a webapplication on a local server).

If you need any other information about this web application, so please ask me.

thanks

Answer 4

User1414178881 posted

In general:

1)Create a table for the emails that should be sent in regular dates depending on your bussiness,columns could be:

i.e id ,from,to,subject,body,interval/date to send......etc

2)Create a windows service that reads regularly from that table,and sends the email(s)

In your web application,all you have to do is to insert a record into that table in DB and that's it.

This is the general idea,so to get you started with it take alook at these links:

http://forums.asp.net/p/1426620/3187210.aspx#3187210 

http://forums.asp.net/p/1495758/3526120.aspx#3531836

http://forums.asp.net/p/1418303/3140894.aspx#3140894

 

Answer 5

User-952121411 posted

I prefer to use a Windows Service to accomplish this task.  Read the following link for details on how to implement a solution to your problem:

Running a Periodic Process in .NET using a Windows Service: 

http://allen-conway-dotnet.blogspot.com/2009/12/running-periodic-process-in-net-using.html

Hope this helps!

Answer 6

User1677448765 posted

go through this article

http://www.highoncoding.com/Articles/32_Scheduling_an_email_using_Windows_Scheduler.aspx

Answer 7

User-1067358373 posted

If you different email tasks to send out at different intervals, take a look at this post.

http://kodethoughts.blogspot.com/2009/06/creating-windows-task-scheduler-service.html