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 |
|
cpnz
Starting Member
3 Posts |
 Posted - 2009-01-21 : 20:05:37
|
| Hi All,I have a fresh install of SQL 2008 Enterprise x64 and am having the following issues with the Agent :Job history is showing 2 rows for some jobsteps, 1 shows as still running, the other showing either failed or completed.The 2nd problem is, some jobs are not retaining more than the last runs worth of history, even though we have not restricted how many lines per job to keep.Has anyone got any thoughts on this?ThanksClint |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
cpnz
Starting Member
3 Posts |
Posted - 2009-01-21 : 20:10:42
|
| No, Retry Attempts are set to 0. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
cpnz
Starting Member
3 Posts |
Posted - 2009-01-21 : 20:19:38
|
| Thanks Tara,I can handle the multiple entries in the history, what is really messing with me is losing ALL the history.Does anyone know if there is an auto purge history feature in 2008? |
|
|
|
|
|
|
SQL Agent History Error