Sql Server 邮件日志 操作

 

删除邮件

EXEC msdb.dbo.sysmail_delete_mailitems_sp @sent_status ='unsent',    @sent_before ='2012-01-01'

 

 查询邮件发送队列

SELECT * FROM msdb.dbo.sysmail_allitems WHERE sent_status='unsent'

 

查询邮件发送事件

SELECT * FROM msdb.dbo.sysmail_event_log