By default the maximum number of logs stored in the SQL SERVER Agent history is 100
All the previous jobs stored after that value are automatically deleted
If you need to store more logs in your history follow these instructions :
- In Object Explorer, connect to an instance of the SQL Server Database Engine, and then expand that instance.
- Right-click SQL Server Agent, and then click Properties.
- In the SQL Server Agent Properties dialog box, select the History page.
Choose from the following options:
- Check Limit size of job history log, and then change the value of the maximum job history rows per job