December 14, 2009 at 2:34 pm
Ok I am stumped, got dbmail to work however, when I wanted to add another name to the receipt line I get an error, can't find anything in BOL which shows how to separate
EXEC msdb.sp_send_dbmail
@profile_name = 'QCSIPRODSQLEXEC',
@recipients = 'user1@msstl.com';'user2@cmsstl.com',
@subject = 'Incorrect QCSD Seq Counts';
If I pull out 2nd name it works
December 14, 2009 at 2:46 pm
timscronin (12/14/2009)
Ok I am stumped, got dbmail to work however, when I wanted to add another name to the receipt line I get an error, can't find anything in BOL which shows how to separateEXEC msdb.sp_send_dbmail
@profile_name = 'QCSIPRODSQLEXEC',
@recipients = 'user1@msstl.com';'user2@cmsstl.com',
@subject = 'Incorrect QCSD Seq Counts';
If I pull out 2nd name it works
Per BOL:
[ @recipients = ] 'recipients'
Is a semicolon-delimited list of e-mail addresses to send the message to. The recipients list is of type varchar(max). Although this parameter is optional, at least one of @recipients, @copy_recipients, or @blind_copy_recipients must be specified, or sp_send_dbmail returns an error.
So,
@recipients = 'user1@msstl.com;user2@cmsstl.com', -- like this
December 14, 2009 at 2:50 pm
Duh, thanks for pointing out the obvious, can't see the trees through the forest
December 14, 2009 at 2:54 pm
No problem, happens to us all at one time or another.
December 14, 2009 at 2:55 pm
Now that I am turning 50 it seems more frequent
December 14, 2009 at 3:02 pm
timscronin (12/14/2009)
Now that I am turning 50 it seems more frequent
I'm right there with you.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply