• Set up the Job History Log by time period

    Connect to Sql Server Instance and right click the Sql Server Agent and select the Properties page. In the SQL Server Agent Properties dialog box select the History page.

    Choose Automatically remove agent history, and specify a time period, history older than this period will be purged from the log.