Using xp_mail

• jvElecenter

  SSCarpal Tunnel

  Points: 4502

  More actions

  April 25, 2002 at 1:33 am

  #101131

  Hi everyone. I've already posted a similar topic, but still I have problems.

  I create a job in the Enterprise Manager, Management. I use the following step :

  Catagory : Uncategorized (local).

  First and last job is a query :

  Exec sb.dbo.xp_sendmail

  @recipients = 'jeffrey'(or I've used my emailadres),

  @query = 'Select nomat, nofact from ventven where codaff = '''

  This job simply doesn't work !!! How ? Why ?

  If I test this job in the query analyzer I've the next result :

  Server: Msg 2812, Level 16, State 62, Line 1

  Could not find stored procedure 'sb.dbo.xp_sendmail'.

  Help me automate !!!!

  Thx

  Jeffrey

  JV

  
  JV

• Antares686

  SSC Guru

  Points: 125444

  More actions

  April 25, 2002 at 4:42 am

  #427826

  I assume sb is the DB you want to query, also master is where xp's live and you have to reference them that way so try.

  Exec master.dbo.xp_sendmail

  @recipients = 'jeffrey'(or I've used my emailadres),

  @query = 'Select nomat, nofact from sb.dbo.ventven where codaff = '''

  "Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

• nitrox

  SSC Veteran

  Points: 270

  More actions

  April 26, 2002 at 9:14 am

  #427952

  Don't you need to start a mail session also? Maybe this is more of a question then an answer.

  Something like this.

  Exec master.dbo.xp_startmail

  Go

  Exec master.dbo.xp_sendmail

  @recipients = 'jeffrey'(or I've used my emailadres),

  @query = 'Select nomat, nofact from sb.dbo.ventven where codaff = '''

  Go

  exec master.dbo.xp_stopmail

  Go

  Thanks,

  Doug

  BTW...

  Thanks Antares686 for the help the other day on my DateAdd function. Worked great!