E-mail To Dynamic Recipients Based on Stored Procedure
Hello everyone, I have a stored procedure that returns a list of users among its output. I would like to configure an e-mail alert to be sent to this list on a daily basis. The stored procedure uses GETDATE() so the list will vary each day it is ran. Is there a simple way to do this in SSMS? Thanks kindly in advance.