34,575
社区成员
发帖
与我相关
我的任务
分享
--应该可以的,楼主好像没有配置好Profile_Name
use Master
GO
sp_configure 'show advanced options',1;
GO
RECONFIGURE;
GO
sp_configure 'Database Mail XPs', 1;
GO
RECONFIGURE
GO
EXEC msdb.dbo.sp_send_dbmail
@profile_name = '配置1',
@recipients = '37112852@qq.com',
@body = 'The stored procedure finished successfully.',
@subject = 'Automated Success Message zhai 13.35' ;