x

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?

more ▼

asked Jul 12, 2013 at 02:37 PM in Default

avatar image

artistlover
866 49 64 68

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?

Jul 12, 2013 at 03:49 PM KenJ
(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

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.

more ▼

answered Jul 18, 2013 at 08:59 AM

avatar image

duliczka
90 1 3 4

It is called "History"

Jul 18, 2013 at 03:12 PM dvroman
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x18

asked: Jul 12, 2013 at 02:37 PM

Seen: 583 times

Last Updated: Jul 18, 2013 at 03:12 PM

Copyright 2018 Redgate Software. Privacy Policy