Home Forums SQL Server 2008 SQL Server 2008 - General Trunacte MSDB tables. RE: Trunacte MSDB tables.
Summer90
SSC-Dedicated
Points: 32891
More actions
January 15, 2013 at 5:25 am
#1577276
I have a job that runs monthly that runs this:
DECLARE @DeleteBeforeDate DateTime = (Select DATEADD(d,-30, GETDATE()))
EXEC sysmail_delete_mailitems_sp @sent_before = @DeleteBeforeDate
EXEC sysmail_delete_log_sp @logged_before = @DeleteBeforeDate