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 |
|
NJDba
Starting Member
31 Posts |
 Posted - 2007-12-17 : 18:41:33
|
| Today when I tried to troubleshoot a failed job, I found out that the job history is disappreared. Some jobs' history still exist. Does anybody have idea what happened? How can I fix it?Thanks a lot. |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-12-17 : 19:57:13
|
| Sql only keeps 1000 history entries by default, but you can change it in sql agent properties. |
 |
|
|
NJDba
Starting Member
31 Posts |
Posted - 2007-12-17 : 20:03:01
|
| I already checked the sql agent's properties. Some jobs' history keep growing, but some jobs'totally gone. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-12-17 : 20:06:00
|
| Anyone cleaned it up? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-12-17 : 20:07:49
|
| By the way, it's not per job. Sql saves most recent 1000 job histories on the server by default. |
|
|
|
|
|
|
Job history disappeared