• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 280
  • Last Modified:

SQL Server 2005 will not keep history longer than 1 day

Have SQL Server 2005 and job keeps history longer than 1 day.

All settings are corect, no maintenance tasks to cleanup any history etc.,

We dont have any job history limits etc.,

Any suggestions
?
0
itmti
Asked:
itmti
  • 4
2 Solutions
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
check the sql server agent settings, there is also a config to delete older job history entries.
also, the jobs can store how many entries they store, which is not linked to time, actually.
0
 
itmtiAuthor Commented:
Checked and was nothing checked.
SQL-Server-Agent.png
0
 
itmtiAuthor Commented:
There was a history cleanup job to cleanup 1 year history, disabled that and trying again.

0
Has Powershell sent you back into the Stone Age?

If managing Active Directory using Windows Powershell® is making you feel like you stepped back in time, you are not alone.  For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why.

 
TempDBACommented:
itmti,
     Is it 1 day or 1 year? Anyway hope this will work.
0
 
itmtiAuthor Commented:
it was 1 year

but disabled completely that part of maintenance and started to work
0
 
itmtiAuthor Commented:
thanks
0

Featured Post

[Webinar] Improve your customer journey

A positive customer journey is important in attracting and retaining business. To improve this experience, you can use Google Maps APIs to increase checkout conversions, boost user engagement, and optimize order fulfillment. Learn how in this webinar presented by Dito.

  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now