brockangelo

This plugin schedules a daily event using wp_cron that deletes all comments marked “spam” in the database, then optimizes the comments table.
Brief reason why I made such a low-tech plugin:
Akismet catches all the spam, but when I was looking at the size of my backups one day, 
I noticed that there were large numbers of comment spam across several sites that were undeleted and they 
made the databases fairly large. So I setup a cron job on my server that deletes the spam.
Since I had never written a plugin, I thought this might be helpful for those who do not have 
a dedicated server, shell access to their site, or the knowledge of (or interest in ) cron to set this up.
Spam is not deleted until you start the schedule after the plugin is activated. I created buttons 
to start and stop the schedule if you need that layer of control. There is also a button for deleting all spam manually.

Delete Spam Daily

Uses wp_cron to delete comments each day that are marked "spam" in the database.

Simon Wheatley

This plugin adds a page in the admin area where you can see all the queued Cron events, when they are due, which schedule they are on (or if they are one off) and which hook they will call. Future development might include:
<ul>
<li>Removing Cron events</li>
<li>Seeing which functions/methods are currently called by which hooks</li>
<li>Manually adding Cron events</li>
<li>Editing Cron events</li>
</ul>
However, do not hold your breath! Development for this plugin will be as and when I need it, or when someone submits a handy patch. I’m definitely open to co-development on this one, so if you want to join in then <a href="http://www.simonwheatley.co.uk/contact-me/" rel="nofollow ugc">contact me</a>.
Any issues: <a href="http://www.simonwheatley.co.uk/contact-me/" rel="nofollow ugc">contact me</a>.

Cron View

Allows you to view all WP Cron events. Handy for development.

Delete Spam Daily vs Cron View