[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 370
  • Last Modified:

Sql jobs on some servers not saving history

I have multiple SQL servers that all run SQL jobs routinely. The jobs on one of the servers are saving NO job history despite the fact that the jobs were all inserted using the same script. Is there a setting particular to the instances of SQL server that controls this? I am trying to troubleshoot some job issues and without any history it is hard to tell what the issue is. The check box to "append output to step history" in the advanced properties of "edit job step" is not checked for both jobs that are recording history and for those that are not.
Thank You!
0
Tommy Jackson
Asked:
Tommy Jackson
  • 3
  • 2
1 Solution
 
Einstine98Commented:
right click on the sql agent and go to job system and you can set the history settings there.
0
 
Tommy JacksonOwnerAuthor Commented:
The settings are the same for all servers. They are set to "limit size" to 1,000 maximum job history rows and 100 maximum job histroy rows per job.
0
 
Einstine98Commented:
if you have more than 10 jobs then maybe some overwriting is taking place, run the job manually and immediately check the history,is it there?
0
 
Tommy JacksonOwnerAuthor Commented:
I ran one this afternoon and it did create history. This particular server does have 3 databases and thus 3 times the jobs as many others. I have changed the max rows to 4,000 and stopped/started the agent. I'll know in the morning when all of the jobs have run. It does seem likely to be the issue. More in the morning.
0
 
Tommy JacksonOwnerAuthor Commented:
Expanding the maximum number of rows allowed for SQL job history did the trick for having history for the jobs. All jobs have history this morning. Thank you for your help!
0

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

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