Press "Enter" to skip to content

Using T-SQL to Find SQL Agent Job History Log Size

Steve Stedman has a T-SQL query for us:

One of the important settings on SQL Server is the job history log size and the maximum rows per job. Without these set accurately you may not be able to track down job failure issues.

Read on to see how you can find the present value, as well as how to set it.