Question on Sql Server jobs

Posted on 2011-04-27
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!
Question by:snyperj
    LVL 40

    Accepted Solution

    Yes. Look into .NET CLR stored procedures
    LVL 9

    Expert Comment

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

    Expert Comment

    by:Alpesh Patel

    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.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Do You Know the 4 Main Threat Actor Types?

    Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

    Suggested Solutions

    Title # Comments Views Activity
    SQL Question 1 26
    Adventure works database .msi 4 39
    SQL Query  get "meddle" records 2 31
    Getting the 3 middle digits 4 25
    INTRODUCTION: While tying your database objects into builds and your enterprise source control system takes a third-party product (like Visual Studio Database Edition or Red-Gate's SQL Source Control), you can achieve some protection using a sing…
    In SQL Server, when rows are selected from a table, does it retrieve data in the order in which it is inserted?  Many believe this is the case. Let us try to examine for ourselves with an example. To get started, use the following script, wh…
    Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
    In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor ( If you're interested in additional methods for monitoring bandwidt…

    737 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

    Need Help in Real-Time?

    Connect with top rated Experts

    22 Experts available now in Live!

    Get 1:1 Help Now