Solved

Auto send email from application

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

Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

Question has a verified solution.

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

Suggested Solutions

This article will inform Clients about common and important expectations from the freelancers (Experts) who are looking at your Gig.
A company’s centralized system that manages user data, security, and distributed resources is often a focus of criminal attention. Active Directory (AD) is no exception. In truth, it’s even more likely to be targeted due to the number of companies …
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 …

749 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