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
?
itmtiAsked:
Who is Participating?
 
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
Creating Active Directory Users from a Text File

If your organization has a need to mass-create AD user accounts, watch this video to see how its done without the need for scripting or other unnecessary complexities.

 
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.

All Courses

From novice to tech pro — start learning today.