e-mail job results

• mannymo

  Grasshopper

  Points: 11

  More actions

  October 15, 2003 at 11:09 am

  #106735

  I have a job setup that executes a sql statement (sp_spaceused). How can I e-mail the results of the job?

• Andy Warren

  SSC Guru

  Points: 119902

  More actions

  October 16, 2003 at 4:40 am

  #478408

  Xp_sendmail supports a query parameter, so it will actually execute a query/proc and email the results.

  Andy

  http://www.sqlservercentral.com/columnists/awarren/

  Andy
  SQLAndy - My Blog!
  Connect with me on LinkedIn
  Follow me on Twitter