This is a mirror of official site: http://jasper-net.blogspot.com/

SQL Database Mail -- Cleanup of Logging Records

| Thursday, January 20, 2011
Similar to SQL Agent logging history, Database Mail has own logging history.  When the logging history is grown too big, you can run T-SQL sysmail_delete_log_sp to clean the logging records.  Several examples of using this stored procedure are provided here.

The article here is assumed that a SQL Database Mail profile "MailProfile1' has been created.  The MailProfile1 tells Database Mail what account it should use to send emails.  For how to create a Database Mail profile, you can refer to the previous post SQL Database Mail - Send Emails from SQL Server.

To delete all records that are generated before 2:37pm, January 17, 2011, run sysmail_delete_log_sp as follows.

-- Start T-SQL
   USE msdb
   EXEC sysmail_delete_log_sp @logged_before='2011-01-17 14:37:00'
-- End T-SQL --

Below is the comparison of log history show before and after deletion.

Read more: SQL Server Agent Team Blog

Posted via email from Jasper-net

0 comments: