Send E-mail at particular Interval

[sumit7034]

Hi I want to send Email to particular users stored in table at a regular interval like 1 hours. I will buy a mail server. I want to know is it possible to do this using sql server. If yes then what approach should I follow to implement this. Thanks in advance

[Garth J Lancaster]

There are lots of approaches here is but one :- Write a .NET Service That 1. Defines a Timer for whatever interval - eg 60 minutes 2 Every interval/timer event, read the database table 3. For every row in the selected users set from the database 3a. construct the email 3b. send email using whatever protocol is applicable for your mail server 'g'

[sumit7034]

Thanks I was also think about this approach. but for eg. Can i host a windows service in web hosting provider like godaddy.com or mochahost.com. so where i host that windows service? If you know any provider where I can host my windows service plz tell. Thanks

[Garth J Lancaster]

no - by 'service' I meant it would run as a win32 service on a windows server type machine - not in/on a web server 'g'

[sumit7034]

Is there any other alternative for this? like using sql server to send mail at particular interval.

[Mycroft Holmes]

You could set up a SQL Server job to send the mail from a stored procedure.

Never underestimate the power of human stupidity RAH

[sumit7034]

Thanks after setting up sqlserver job am I able to send mail to all the users stored in my table? Is there option that this process repeat itself after every hour like a timer?

[Mycroft Holmes]

Yes SQL server has a scheduler which will repeat the job as often as you like.

Never underestimate the power of human stupidity RAH