16
SQL Server – Database Mail 刪除Mail紀錄和郵件
**** 刪除Mail紀錄 ************************************************
–刪除所有Mail紀錄
exec sysmail_delete_log_sp
–刪除所有Mail發送成功的紀錄
exec sysmail_delete_log_sp @event_type = ‘success’
–刪除所有Mail警示的紀錄
exec sysmail_delete_log_sp @event_type = ‘warning’
–刪除所有Mail發送錯誤的紀錄
exec sysmail_delete_log_sp @event_type = ‘error’
–刪除所有Mail為information的紀錄
exec sysmail_delete_log_sp @event_type = ‘information’
–刪除所有Mail為特定日期之前的紀錄
exec sysmail_delete_log_sp @logged_before = ‘2013-01-01′
–刪除所有Mail為 7 天以前的紀錄
DECLARE @DeleteBeforeDate DateTime
SELECT @DeleteBeforeDate = DATEADD(d,-7, GETDATE())
EXEC sysmail_delete_log_sp @logged_before = @DeleteBeforeDate
**** 刪除Mail紀錄 ************************************************
–刪除所有Mail狀態為「已發送」的郵件
exec sysmail_delete_mailitems_sp @sent_status=’sent’
–刪除所有Mail狀態為「未發送」的郵件
exec sysmail_delete_mailitems_sp @sent_status=’unsent’
–刪除所有Mail狀態為「重試中」的郵件
exec sysmail_delete_mailitems_sp @sent_status=’retrying’
–刪除所有Mail狀態為「發送失敗」的郵件
exec sysmail_delete_mailitems_sp @sent_status=’failed’
–刪除所有Mail為 7 天以前的郵件
DECLARE @DeleteBeforeDate DateTime
SELECT @DeleteBeforeDate = DATEADD(d,-7, GETDATE())
EXEC sysmail_delete_mailitems_sp @sent_before = @DeleteBeforeDate
There are no comments.