Home Forums SQL Server 2005 Administering Clearing out msdb.dbo.sysmail_mailitems... RE: Clearing out msdb.dbo.sysmail_mailitems...

  • October 18, 2012 at 7:52 am

    #1550498

    the scriptlet i posted is what i've put in a scheduled job before;

    just letting it run once a day deletes anything older than 30 days;

    that's what would be my simple sugestion to keep the data under control, especially if you have a fairly busy usage of database mail.

    DECLARE @DeleteBeforeDate DateTime

    SELECT @DeleteBeforeDate = DATEADD(d,-30, GETDATE())

    EXEC sysmail_delete_mailitems_sp @sent_before = @DeleteBeforeDate

    EXEC sysmail_delete_log_sp @logged_before = @DeleteBeforeDate

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!