For our environment test we need to configure sp_send_dbmail to send emails only to certain recipients. Let's say a stored procedure executes the following code:
EXEC msdb.dbo.sp_send_dbmail @email@example.com'; 'firstname.lastname@example.org', @body = @myBody, @subject = @mySubject, @profile_name =@myProfileName
I need the email to be sent only to email@example.com, and not to firstname.lastname@example.org. Is there a way that i can configure this? Changing realusers email address won't do it for me.