DELETE FROM msdb.dbo.sysmail_allitems 
   WHERE 
        ((@sent_before IS NULL) OR ( send_request_date < @sent_before))
   AND ((@sent_status IS NULL) OR (sent_status = @sent_status))

USE MSDB;
GO

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

   DELETE FROM msdb.dbo.sysmail_allitems 
   DELETE FROM msdb.dbo.sysmail_log 

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

exec sp_spaceused 'msdb.dbo.sysjobhistory'

DECLARE @oldestdate DATETIME
SET @oldest = GETDATE() - 30
EXEC SP_PURGE_JOBHISTORY @oldest_date = @oldestdate