sql server - How does sp_send_dbmail convert the query into text in the email body -

sql server - How does sp_send_dbmail convert the query into text in the email body -

i'm trying add together "signature" @ bottom of stored procedure show job ran it, server run on, , stored procedure name (i have code figured out). if seek insert signature, placed above query result in email. trying capture text result manually add together email body can place signature underneath it.

how sql server convert query text displayed in email using exec msdb.dbo.sp_send_dbmail?

furthermore, there way can capture text local variable?

if examine sp_send_dbmail stored procedure, can see it's doing. short version

runs query , stores results in scheme table (sysmail_mailitems), along other message details sends message mail service queue an external mail service service constructs , sends message recipients

the point there no easy way customize how email message assembled. you'll improve off designing sort of external process of own build , send email.

sql-server tsql