SQL SERVER: Clear Job History

Recently, we have implemented few jobs and we were testing the jobs. After our test runs successfully, we wanted to clear Job’s history, so we can have accurate job status. I have found following SQL to delete job’s history: USE msdb GO EXEC dbo.sp_purge_jobhistory @job_name = '<Job Name>' This will clear all history for the specified job. If you wanted to clear job history up to specific date, you can use following: USE msdb GO EXEC dbo.sp_purge_jobhistory @job_name = '<Job Name>' , @oldest_date='2012-10-10' If you wanted to clear job history for ALL SQL jobs, you should just execute: USE msdb GO EXEC dbo.sp_purge_jobhistory Reference: Tejas Shah (http://www.SQLYoga.com)