删除邮件
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
删除邮件
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
转载于:https://www.cnblogs.com/machaofast/archive/2013/03/07/2947316.html