Creating Email Alerts

Posted on 2005-04-19
Last Modified: 2010-04-16
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 to send out the emails.

Is this the right way of doing this.


Question by:nparrett
    LVL 2

    Accepted Solution

    This sounds plausible to me. You want to look at the System.Web.Mail namespace:

    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:
    LVL 8

    Expert Comment

    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.



    Featured Post

    Threat Intelligence Starter Resources

    Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

    Join & Write a Comment

    Suggested Solutions

    Article by: Najam
    Having new technologies does not mean they will completely replace old components.  Recently I had to create WCF that will be called by VB6 component.  Here I will describe what steps one should follow while doing so, please feel free to post any qu…
    Real-time is more about the business, not the technology. In day-to-day life, to make real-time decisions like buying or investing, business needs the latest information(e.g. Gold Rate/Stock Rate). Unlike traditional days, you need not wait for a fe…
    Hi everyone! This is Experts Exchange customer support.  This quick video will show you how to change your primary email address.  If you have any questions, then please Write a Comment below!
    This video discusses moving either the default database or any database to a new volume.

    754 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    20 Experts available now in Live!

    Get 1:1 Help Now