Posted on 2012-03-14
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 each day? If yes, then where can we schedule it and how we can send the result in HTML format?
How do I return the info from this stored procedure
How do I properly format this info
@profile_name = 'AdminAccount',
@recipients = 'firstname.lastname@example.org',
@subject = 'T-SQL Query Result',
@body = 'The result from EmployeeHireProcedure',
@execute_query_database = 'msdb',
@query = 'Exec Billing.MerchantInfo @StartDate,@EndDate ,11'
Thanks In Advance for any suggestions