Is there a way by using which we can use the Database mail service to send the result of a stored procedure that will be scheduled to run at a specific time in a day? If yes, then where can we schedule it and how we can send the result in HTML format?
Please help..
Rohit