SQL Server 2008 Emailing script

 

declare @dbname varchar(100)
set @dbname = DB_NAME()
declare @sql varchar(6800)
 
-- 2.5
print '2.5'
select @sql='select it.reviewstate as [Review State], count(*) as [Count]
from dbo.LatestApprovedPlusDraftItems it
where it.deleted = 1
group by it.REVIEWSTATE'
exec master..spExportData @dbname, @sql, 'D:\DataConversionReports\6.2.2\Report61.xls'

 

-- send 6.2.2 reports
EXEC msdb.dbo.sp_send_dbmail @profile_name='xxx Automated Mailer',
@recipients='xxx@xxx.com',
@subject='Data Migration Section 6.3.1 Reports',
@file_attachments='D:\DataConversionReports\6.2.2\Report61.xls;D:\DataConversionReports\6.2.2\Report62.xls';