Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2012
    Posts
    37

    Unanswered: How ro schedule the job and mail the desired result

    Hi All
    I am new to Sql Server, In my system the Sql Server 2005 is installed, What i want to do is-:
    to run the following query at a particular time, And the result of that query should be mailed to desired users.

  2. #2
    Join Date
    Aug 2004
    Location
    Dallas, Texas
    Posts
    831
    SSIS and SQL Agent job.

  3. #3
    Join Date
    Mar 2012
    Posts
    37
    Any example

  4. #4
    Join Date
    Aug 2004
    Location
    Dallas, Texas
    Posts
    831
    Quote Originally Posted by goodman2253 View Post
    Any example
    I don't think it's possible for me to load an SSIS package. There are tasks you can use for executing sql commands, and then email the results.

    Alternatively, review the xp_sendmail BOL. Some folks use this extended sproc to send query results to people.

    xp_sendmail (Transact-SQL)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •