If Query Returns results send a email

• Suth

  SSCommitted

  Points: 1559

  More actions

  October 31, 2016 at 8:29 am

  #314999

  Hi,

  I'm trying to send returned results of a query only if something is returned back in the query through the sp_send_dbmail function..

  I've tried to use the following but it doesn't seem to be working.....

  IF EXISTS (SELECT [QUERY HERE])

  BEGIN

  EXEC msdb.dbo.sp_send_dbmail

  @profile_name = 'Adventure Works Administrator',

  @recipients = 'yourfriend@Adventure-Works.com',

  @subject = 'Test',

  @attach_query_result_as_file = 0 ;

  end

  any ideas ?

• Phil Parkin

  SSC Guru

  Points: 247172

  More actions

  October 31, 2016 at 8:39 am

  #1909650

  Suth (10/31/2016)

  ---

  Hi,

  I'm trying to send returned results of a query only if something is returned back in the query through the sp_send_dbmail function..

  I've tried to use the following but it doesn't seem to be working.....

  IF EXISTS (SELECT [QUERY HERE])

  BEGIN

  EXEC msdb.dbo.sp_send_dbmail

  @profile_name = 'Adventure Works Administrator',

  @recipients = 'yourfriend@Adventure-Works.com',

  @subject = 'Test',

  @attach_query_result_as_file = 0 ;

  end

  any ideas ?

  'Not working'. Is that all of the information you are prepared to give us?

  Is there an error message?

  Does the statement work if you issue it unconditionally?

  ---

• HanShi

  SSC-Dedicated

  Points: 33515

  More actions

  October 31, 2016 at 8:42 am

  #1909653

  You'll also need to use parameter "@query = " when calling the sp_send_dbmail procedure. Look in BOL for a complete list of parameters.

  ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **

• Jeff Moden

  SSC Guru

  Points: 1004615

  More actions

  October 31, 2016 at 10:34 am

  #1909693

  Question now is, what the hell happened to my post which included code to do this (or maybe this is a duplicate post)? I'll see if I saved the example somewhere and try to repost it tonight.

  --Jeff Moden

  ---

  RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
  First step towards the paradigm shift of writing Set Based code:
  ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

  Change is inevitable... Change for the better is not.
  

  ---

  Helpful Links:
  How to post code problems
  How to Post Performance Problems
  Create a Tally Function (fnTally)
  

• Phil Parkin

  SSC Guru

  Points: 247172

  More actions

  October 31, 2016 at 10:46 am

  #1909698

  Deleted.

  ---