Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 179
  • Last Modified:

Creating Email Alerts

Hi there,

I am running a jobs/motors and property website for a newspaper.  I am looking to setup email alerts for these websites.  Such as email me jobs like these, email me cars like this and email me properties like these.

The average character length of the email exceeds around 16000.  Therefore making direct emailing from sql a non option (due to restrictions of the nvarchar field in the message body).

Therefore I have come up with the conclusion that I need to design a windows app that is permanently running with has a scheduler which runs daily that pulls info from the database and uses a component such as smtp.net to send out the emails.

Is this the right way of doing this.

Thanks

Nathan
0
nparrett
Asked:
nparrett
1 Solution
 
SThorogoodCommented:
This sounds plausible to me. You want to look at the System.Web.Mail namespace:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlrfSystemWebMail.asp

Also to create a background process, you might want to consider a windows service. Creating and deploying a simple service with a timer in C# is relatively straightforward. See:

http://www.ondotnet.com/pub/a/dotnet/2003/08/18/winservices.html
0
 
Razzie_Commented:
One advice I'd like to give is, that if your email scheduler runs on a set time everyday, for example, every night at 3:00 am, you may want to use a normal window executable program that is executed using the scheduled tasks manager, and not a windows service. Using a windows service for this would just be a waste of processor times, as it runs 24/7, while simply starting the program once a day would not.

HTH,

Razzie
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now