?
Solved

Auto send email from application

Posted on 2011-03-21
1
Medium Priority
?
322 Views
Last Modified: 2012-06-21
I am searching for ideas on how best to accomplish a small programming task.

I have a script that runs at intervals and retrieves data from a backoffice db on an old AIX system and puts it onto an SQL 2008 server db. No problem here. New data only gets pushed to the SQL server if there is anything new to add.
Example...

Apple Price changes daily at 17:00...but could change at any time during the day if there is an intra-day price change.
Script machine polls AIX machine every 15 mins. If there is any new price for Apples that data is pushed to the SQL server.

I will write a WPF app that will pretty much run all the time...and poll the SQL server to see if the price of Apples has changed. If it has then I would like the app to email a group of individuals that this price has changed. The emailing the group is the item I am most interested in. I can do the code for all of this but it seems clunky and cumbersome. Is there some easier method someone can think of to accomplish this task.

Thanks in Advance!
0
Comment
Question by:IronDriver
1 Comment
 
LVL 12

Accepted Solution

by:
Paul_Harris_Fusion earned 2000 total points
ID: 35181947
You could use a trigger to detect the change and send the email direct from SQL server rather than write a WPF app.

http://www.sqlservercurry.com/2008/02/how-to-send-email-using-sql-server-2005.html
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
Among the most obnoxious of Exchange errors is error 1216 – Attached Database Mismatch error of the Jet Database Engine. When faced with this error, users may have to suffer from mailbox inaccessibility and in worst situations, permanent data loss.
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
SQL Database Recovery Software repairs the MDF & NDF Files, corrupted due to hardware related issues or software related errors. Provides preview of recovered database objects and allows saving in either MSSQL, CSV, HTML or XLS format. Ensures recov…

615 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