email users depending on result of query

• Dana Bibeault

  Hall of Fame

  Points: 3670

  More actions

  August 1, 2007 at 9:08 am

  #125142

  Hi, what is the easiest way to email users if a query returns any records?  Do DTS packages have functins for this or do we go the run a query from a Agent job?

  Case is like this, if a query returns more than 0 records we want to notify two users via email.  email is set up on the server.

   

   

• bdohmen

  SSCrazy

  Points: 2996

  More actions

  August 1, 2007 at 9:28 am

  #723923

  You should be able to add an Execute SQL Statement step into your DTS.  Then use XP_SendMail in the SQL statement.

  Brian