arooj300 (7/18/2014)
How can I send mail to the mulltiple user . Do i need to configure one more profile or in one profile we can send to the multiple user.
multiple users are defined as a semi colon delimited list in the to/cc/bcc parameters. they follow the standard rules for alias + <email>, or just as email addresses with no name/alias:
EXEC msdb.dbo.sp_send_dbmail
@profile_name='mydomain Database Mail',
@recipients='groupmail@mydomain.com;Lowell Izaguirre<lizaguirre@mydomain.com>;Brad Pitt <bpitt@mydomain.com>;Sylvester Stallone <sstallone@mydomain.com>',
@subject = 'Example SQL Alert ',
@body = @HTMLBody,
@body_format = 'HTML';
Lowell