Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Analyzer
Posting Yak Master
115 Posts |
 Posted - 2008-06-23 : 07:46:12
|
| Recently the Agent on our production server has exhibited a condition where the agent history is missing on around 80% of our jobs. The jobs still run but no history, we have cycled the services, rebooted etc but nothing rememdies the issue.Has anyone else ever ecountered this with SS and if so do you have a solution? |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-06-23 : 09:12:08
|
| Check out jobhistoy table in MSDB. |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-06-23 : 22:58:20
|
| How many job histories do you keep? Default is 1000. |
|
|
|
Analyzer
Posting Yak Master
115 Posts |
Posted - 2008-06-24 : 04:19:00
|
| Correct - there is 1000 rows within dbo.sysjobhistory. Around the same time as the problem manifested itself I setup 14 applications to Log Ship every 15 minutes; so has the increased volume on executed jobs breached a threshold which it can store? |
|
|
|
Analyzer
Posting Yak Master
115 Posts |
Posted - 2008-06-24 : 04:26:50
|
| I have increased the default history row count within the SQL Agent Properties - www.mssqltips.com/tip.asp?tip=1269 |
|
|
|
|
|
|
Agent History Intermittently Missing Condition