• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 226
  • Last Modified:

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!
0
snyperj
Asked:
snyperj
1 Solution
 
mrjoltcolaCommented:
Yes. Look into .NET CLR stored procedures

http://msdn.microsoft.com/en-us/library/ms131094(v=SQL.90).aspx
0
 
radcaesarCommented:
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
0
 
Alpesh PatelAssistant ConsultantCommented:
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.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: CompTIA Cloud+

The CompTIA Cloud+ Basic training course will teach you about cloud concepts and models, data storage, networking, and network infrastructure.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now