here is an example how to send an email and the result to be formated in HTML

create procedure stp_check_smth_and_send_email

as

declare

@table nvarchar(max)

,@cnt int

,@durration int

--format email that will be send if the...

try this....

http://www.tutorialesql.com/creare-baze-de-date-in-sql-server/

select * from sys.tables

http://www.tutorialesql.com/