Clear the Job History Log
This topic describes how to delete the contents of the Microsoft SQL Server Agent job history log in SQL Server 2016 by using SQL Server Management Studio, Transact-SQL, or SQL Server Management Objects.
In This Topic
Before you begin:
To clear the job history log, using:
For detailed information, see Implement SQL Server Agent Security.
In Object Explorer, connect to an instance of the SQL Server Database Engine, and then expand that instance.
Expand SQL Server Agent, and then expand Jobs.
Right-click a job and click View history.
In the Log File Viewer, select the job for which you want to clear history, and then do one of the following:
Click Delete, and then click Delete all history in the Delete History dialog. You can delete all job history or only history that is older than a specified date. If you want to remove all job history, click Delete all history. If you only want to remove older job history logs, click Delete history before, and then specify a date.
Click Job status if you want to clear the history log of a multiserver job. Click Job, click a job name, and then click View Remote Job History.
In Object Explorer, connect to an instance of Database Engine.
On the Standard bar, click New Query.
Copy and paste the following example into the query window and click Execute.
-- example removes the history for a job named NightlyBackups. USE msdb ; GO EXEC dbo.sp_purge_jobhistory @job_name = N'NightlyBackups' ; GO
To clear the job history log
Use the PurgeJobHistory method of the JobServer class by using a programming language that you choose, such as Visual Basic, Visual C#, or PowerShell. For more information, see SQL Server Management Objects (SMO).