We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

Question on Sql Server jobs

snyperj
snyperj asked
on
Medium Priority
239 Views
Last Modified: 2012-05-11
Our biz system uses SQL Server 2005 a the back end.

We would like to automatically email a link to a web survey to certain customers when there order completes.

The trigger in the database would be an invoice being generated (means the job is complete in our process.)

Can a SQL Server job be built to send an email such as this?  Can anyone point me to some info on creating these?  Thanks!
Comment
Watch Question

Top Expert 2009
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
1. Create an .NET Application for your survey (Get input and save the user survey details).

2. Retrieve the order completed customers (Else any apps)

3. Send mail using xp_sendmail (with attachment of a html file with your survey application url) to the urls retrieved in step 1.

http://msdn.microsoft.com/en-us/library/aa155737(v=office.10).aspx
Alpesh PatelSolution Architect at TCS (SAFe®Agilist, TOGAF® Foundation, PSM I®, MCP, MCSD)
CERTIFIED EXPERT

Commented:
Hi,

1. Please configure DBMail in SQL SErver
2. Create TRigger on table which have a status of order (which is completed)
3. Send mail using db_sendmail SP to send mail.
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.