Sql-Server 邮件相关的查询和删除

最新推荐文章于 2022-05-24 14:13:18 发布

weixin_30848775

最新推荐文章于 2022-05-24 14:13:18 发布

阅读量471

点赞数

文章标签：数据库

原文链接：http://www.cnblogs.com/hironpan/p/8475968.html

版权

-- 查询邮件发送记录和报告
SELECT TOP(50) * FROM msdb.dbo.sysmail_allitems ORDER BY mailitem_id DESC
SELECT TOP(50) * FROM msdb.dbo.sysmail_event_log ORDER BY log_id DESC

-- 删除指定时间之前的邮件发送记录和报告
EXECUTE msdb.dbo.sysmail_delete_mailitems_sp @sent_before = '2018-03-01 00:00';
GO
EXECUTE msdb.dbo.sysmail_delete_log_sp @logged_before = '2018-03-01 00:00';
GO

参考：
https://docs.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sysmail-delete-mailitems-sp-transact-sql
https://docs.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sysmail-delete-log-sp-transact-sql

转载于:https://www.cnblogs.com/hironpan/p/8475968.html