SQL SERVER – How to increase the maximum number job history logs

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

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s