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 @firstname.lastname@example.org'; 'email@example.com', @body = @myBody, @subject = @mySubject, @profile_name =@myProfileName
I need the email to be sent only to firstname.lastname@example.org, and not to email@example.com. Is there a way that i can configure this? Changing realusers email address won't do it for me.