data base email

Question

Dear All,

           Here i developed a report using gridview control my web site.

now i want to send an email the same report(means same result set) data from sql server 2005 every day at 9pm.

how can i configure the set up.

please help me out.....

thank you..

Answer 1

Hi

Check out the below link,

http://www.sql-server-performance.com/articles/dba/email_functionality_p1.aspx

Thanks -- Vijaya Kadiyala

Answer 2

Create a SQL Server Transact-SQL Job and schedule it to run at 9 everyday with e-mail code in it:

msdb.dbo.sp_send_dbmail

@recipients=N'[e-mail]',
@body='Body', 

@subject ='Subject',
@file_attachments ='report path';