How can I clear the 'History' tab of an episerver scheduled job?

My Scheduled job has too much history and I would like to remove it. How can I do this?

Answer

Why not look up the pkID based on the scheduled job name in table tblScheduledItem then run DELETE FROM tblScheduledItemLog WHERE fkScheduledItemId = 'the pkID you looked up';

Additional Posts

If your history tab has too much in it, you can remove it from the database with the following query.

TRUNCATE TABLE tblScheduledItemLog;

Comments

• Note: this will remove all history for all scheduled jobs.  +1 Internet points to whoever writes up how to clear for just one job.
• seems like bad practice to remove it all. Is there a date associated? Can we remove by date?