Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 281
  • 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
Problems using Powershell and Active Directory?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. 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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

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