Create PROCEDURE [dbo].[job_AutoMail_xxd] AS BEGIN SET NOCOUNT ON; --获取数据 truncate table Db_Name.dbo.Table_Name insert into Db_Name.dbo.Table_Name select * from openquery(Link_Name,'exec store_procedure_name') exec master..xp_cmdshell 'del c:/*.xls' EXEC master..xp_cmdshell 'bcp 数据库名.表名 out c:/temp1.xls -c -q -S 服务名 -U sa -P 密码 --定义邮件参数 DECLARE @To AS varchar(500) SET @To = 'to