Database Mail has a couple of log tables in the msdb database. These can become large over time. I’ve seen MSDB databases over 1 GB in size, where normal size is less than 50 MB (heavy usage of old SSIS deployment model excluded).
Unfortunately Maintenance Plans do not have built-in functionality for this, nor does Ola Hallengren’s excellent maintenance solution ( http://ola.hallengren.com/ ). All you have to do is to schedule an agent job to be executed, say, every week, having one T-SQL jobstep containing:
DECLARE @DeleteOlder DATETIME
SET @DeleteOlder = DATEADD(MONTH, -1, CURRENT_TIMESTAMP)
EXECUTE msdb.dbo.sysmail_delete_mailitems_sp @sent_before = @DeleteOlder
EXECUTE msdb.dbo.sysmail_delete_log_sp @logged_before = @DeleteOlder
Above removes mail history older than one month. Adjust to your liking, using the values in the DATEADD function.
As always, remember to comment your job and to specify appropriate database for the T-SQL jobstep (for documentation purposes, msdb in this case).
Yo, anyone know where to find ‘gà chọi c1.com’ streams? Hoping this site does the trick lets see some action! Here it is: gà chọi c1.com.
Brabet4br has become one of my favorites quickly! Huge selection of Games with awesome Bonus. Try It, you wont regret. You can find it brabet4br.
Look, it’s gà chọi c1.com. Still leading to gachoic1com.com, which… we all know what that is by now. Proceed with caution. Find it here: gà chọi c1.com
Pin Up Casino? Oh man, talk about a blast from the past with a modern twist. Love the retro vibe and they actually have some cool bonuses going on. I’ve hit a few decent wins there lately. Definitely worth checking out if you’re into that pin-up aesthetic. Check them out: pinupcassino