• 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!
1 Solution
Yes. Look into .NET CLR stored procedures

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.

Alpesh PatelAssistant ConsultantCommented:

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.
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