Sql 邮件发送
时间：2021-07-01 10:21:17
帮助过：2人阅读
name
from msdb.dbo.sysmail_profile
--
邮件发送日志
SELECT *
FROM msdb.dbo.sysmail_event_log
delete FROM msdb.dbo.sysmail_event_log
--
邮件内容
SELECT *
FROM msdb.dbo.sysmail_allitems
delete FROM msdb.dbo.sysmail_allitems
EXEC msdb.dbo.sp_send_dbmail
@profile_name =
‘test‘,
@recipients =
‘XXX@XXX.com‘,
@subject =
‘mail test‘,
@body =
‘Hi!‘
Sql 邮件发送
标签：
