Solved

Auto send email from application

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

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

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

Suggested Solutions

In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
This is about my first experience with programming Arduino.
In this fifth video of the Xpdf series, we discuss and demonstrate the PDFdetach utility, which is able to list and, more importantly, extract attachments that are embedded in PDF files. It does this via a command line interface, making it suitable …
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…

813 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

19 Experts available now in Live!

Get 1:1 Help Now