sp_send_dbmail - send to operator

Question

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

Geoff A SSChampion Points: 11511 More actions · Answer 1

declare @oper_email nvarchar(100)

set @oper_email = (select email_address from msdb.dbo.sysoperators)

EXEC msdb.dbo.sp_send_dbmail @profile_name = 'SQLMail Profile',

@recipients = @oper_email, @copy_recipients = '',

@importance = 'High', @subject = 'Email Subject',

@body = 'Email Body....hi this is test email', @body_format = 'HTML' ;

-- if you have multiple operators, this WILL NOT WORK...

C# Gnu SSCertifiable Points: 5973 More actions · Answer 2

Oh thats great thanks Geoff.

I know the name of the operator so I can filter on name ='bla'.

BTW I have my operator defined with multiple email addresses 'someone@leansoftware.net;someone_else@leansoftware.net'

I suppose I should create an NT Group and specify that as the email address, mind you the above list approach seems to work ok for me in sql 2008.

Thanks again!

C# Gnu
____________________________________________________