xp_smtp_sendmail

does anybody have a list of all parameters for xp_smtp_sendmail?  i'm looking all over the place, haven't yet found one.
LVL 17
dbaSQLAsked:
Who is Participating?
 
Aneesh RetnakaranConnect With a Mentor Database AdministratorCommented:
               http://www.sqldev.net/xp/xpsmtp.htm
0
 
dbaSQLAuthor Commented:
let me expand this question just a bit  --

i am trying to do this on a scheduled basis, sending the results in the body of an email:

EXEC master..xp_sendmail @recipients ='me@mydomain.com',
@query = 'exec db.dbo.procname ''parameter1'',''parameter2'',''parameter3'',''parameter4'',''parameter5''   ',
@subject='test',
@attach_results = 'false'

when running in QA, without @attach_results, xp_sendmail runs fine, the email was sent, but the body was blank.
so i'm not sure that it ran the @query

what am i missing?
0
 
dbaSQLAuthor Commented:
very good, aneeshattingal.  thank you for the parameters.  any thoughts on my bigger issue?
0
Take Control of Web Hosting For Your Clients

As a web developer or IT admin, successfully managing multiple client accounts can be challenging. In this webinar we will look at the tools provided by Media Temple and Plesk to make managing your clients’ hosting easier.

 
dbaSQLAuthor Commented:
i see @query isn't in there w/all the xp_smtp_sendmail parameters
but, xp_sendmail is fine, if i can get the proc results into the body of the email
0
 
Anthony PerkinsConnect With a Mentor Commented:
You need to decide which protocol you want to use xp_smtp_sendmail (SMTP) or xp_sendmail (MAPI).

And no, you cannot use xp_smtp_sendmail to send a query. It does not work that way.
0
 
dbaSQLAuthor Commented:
i guess I just wasn't thinking about it the right way this morning when i submitted this inquiry.  
i am using xp_smtp_sendmail in a bit of a customized by bill wunder.  (see:  http://www.sswug.org/see/15091)

i didn't know, though, that @query wasn't a parameter for xp_smtp_sendmail.  i thought surely it was available to me.
0
 
dbaSQLAuthor Commented:
thank you both.  i am splitting as my question was split and then answered by both of you
again, thank you both very much
0
All Courses

From novice to tech pro — start learning today.