question

artistlover avatar image
artistlover asked

SQL Server Agent

I have multiple servers ranging from 2000 & 2005 and 2008 Sql Running. Some of the db's keep job history and others do not. I have checked sql agent job properties they were all set same. I'm at a loss and researching was not providing with explanation. Any ideas?
sql-server-agent
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

What are the settings on "Limit size of job history log" including maximum row sizes? On the 2005 and newer servers, how is "Remove agent history" set? Do you have any jobs running that might occasionally "clean up" the history? Have you restored msdb on any of the servers that might have changed the amount of history on a server? Is history being lost for all jobs or just some?
2 Likes 2 ·

1 Answer

·
duliczka avatar image
duliczka answered
I don't know if that helps, but in Management Studio you could rightclick on the SQL Server Agent (the agent, not the jobs) to get the properties. On the left side hit the last entry (I don't know how it is named in the English version). There you can set the maximum count of history entries total, the maximum count of history entries per job and you can set the option, that entries older than xxx will be automatically deleted. There is no possibility to set the history settings on job level but only on service-level.
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

It is called "History"
2 Likes 2 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.