Sql 邮件发送
标签：
Sql 邮件发送
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!‘