exec sp_configure 'show advanced options', 1
go
reconfigure
go
exec sp_configure 'xp_cmdshell', 1
go
reconfigure
go


exec xp_cmdshell 'del C:\Files\test.xls'
go
exec xp_cmdshell 'copy C:\Files\ForSend\test.xls C:\Files'
go
insert opendatasource('Microsoft.Jet.OLEDB.4.0', 'Data Source=C:\Files\test.xls;Extended Properties=Excel 8.0')...[Лист1$] select * from [StatDB]..etalon_fns 
go



declare @Nowday nvarchar(max);
declare @tableHTML nvarchar(max);
set @Nowday = convert(varchar,getdate(),106)

SET @tableHTML =
      N'<h3> ИНФА   :' +  @Nowday + ' </h3>' 


exec msdb.dbo.sp_send_dbmail
@recipients =N'test@.ru',
@body = @TableHTML,
@body_format ='HTML',
@subject ='ИНФА',
@profile_name ='Статистика',
@file_attachments='C:\Files\test.xls'

go
exec sp_configure 'xp_cmdshell', 0
go
reconfigure
go
exec sp_configure 'show advanced options', 0
go
reconfigure
go