April 17, 2008 at 1:13 am
Hi all,
i created one job with the schedule of every 10 minutes,
while viewing the history of that job,
i got the results on the current date only (today)
i want the history of yesterday or day before yesterday how can i got it?
Thanks and Regards,
N.Prabhakaran
April 17, 2008 at 6:24 am
Right-click on the Job Agent in the treeview in Management Studio and bring up it's properties.
Go to the History section and make sure your job history is not being cleared too soon on you.
I think by default it only saves 100 rows of history per job.
April 18, 2008 at 4:25 am
Michael is right - you need to update the number of history rows stored for the job.
You also need to go into SQL Agent properties and increase the maximum number of history rows stored in msdb, and expect your msdb to grow to a few hundred MB.
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply