Sql Mail

• jeca73

  SSC-Addicted

  Points: 428

  More actions

  April 8, 2002 at 8:49 am

  #63813

  Hi,

  I'm going to run a scheduled job and send the results from my local SQL SERVER 2000 and it works when I am login to my computer, but I need to send them too when I am logoff.How to solve that problem?

  Thanks a lot,

  Jelena

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736478

  More actions

  April 8, 2002 at 9:52 am

  #426786

  You need to setup SQL Mail and use xp_sendmail.

  Some resources:http://www.sqlservercentral.com/columnists/sjones/sqlmailresources.asp

  Steve Jones

  steve@dkranch.net