May 10, 2016 at 2:37 am
Hello,
SQL Job is not showing longer history, it shows about 4 - 5 days of history. Is there anyway to increase the limit to at least a month?
Please help
Thanks!
May 10, 2016 at 2:57 am
Hi,
right mouse click on the SQL Server Agent
=> Properties
=> History
Here you can change the value for the history of the jobs.
If you had jobs with many schedules, you need more than 1000 rows.
Kind regards,
Andreas
May 10, 2016 at 7:52 am
You want to go into the SQL Server Agent Properties and click on history and increase the maximum job history log size.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
May 10, 2016 at 10:13 pm
Enter filter parameters
Connect to an instance of the SQL Server Database Engine
Expand SQL Server Agent >> expand Jobs.
Right-click a job >> click View History
In the Log File Viewer >> click the Filter button and enter filter parameters
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply