Solved

Auto send email from application

Posted on 2011-03-21
1
310 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 500 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

What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

Join & Write a Comment

Suggested Solutions

Since upgrading to Office 2013 or higher installing the Smart Indenter addin will fail. This article will explain how to install it so it will work regardless of the Office version installed.
If you’re thinking to yourself “That description sounds a lot like two people doing the work that one could accomplish,” you’re not alone.
In this fourth video of the Xpdf series, we discuss and demonstrate the PDFinfo utility, which retrieves the contents of a PDF's Info Dictionary, as well as some other information, including the page count. We show how to isolate the page count in a…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

747 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

13 Experts available now in Live!

Get 1:1 Help Now