USE msdb
GO
EXEC dbo.sp_purge_jobhistory
@job_name = '<Job Name>'
USE msdbIf you wanted to clear job history for ALL SQL jobs, you should just execute:
GO
EXEC dbo.sp_purge_jobhistory
@job_name = '<Job Name>' ,
@oldest_date='2012-10-10'
USE msdb
GO
EXEC dbo.sp_purge_jobhistory
Microsoft Certified Professional Expert. I have 14+ years of experience in Design and Develop 100+ .Net applications using Asp.Net, C#, Asp.Net Core, VB.Net, SQL Server, MVC, AngularJS, JavaScript, Azure, HTML5 and CSS3.
Posted by Tejas Shah on November 22, 2017
Posted by Tejas Shah on November 11, 2017
Posted by Tejas Shah on August 12, 2015
Posted by Tejas Shah on June 26, 2015
Posted by Tejas Shah on April 20, 2015