Link to home
Start Free TrialLog in
Avatar of snyperj
snyperjFlag for United States of America

asked on

Question on Sql Server jobs

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!
ASKER CERTIFIED SOLUTION
Avatar of mrjoltcola
mrjoltcola
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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
Avatar of Alpesh Patel
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.