How to: Clear the Job History Log (SQL Server Management Studio)

This topic describes how to delete the contents of the Microsoft SQL Server Agent job history log.

To clear the job history log

  1. In Object Explorer, connect to an instance of the SQL Server Database Engine, and then expand that instance.

  2. Expand SQL Server Agent, and then expand Jobs.

  3. Right-click a job and click View history.

  4. 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.

  5. Click Delete.

See Also

Concepts