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 |
|
GRAYWOLF
Posting Yak Master
106 Posts |
 Posted - 2009-02-05 : 05:25:42
|
| I have a job that runs every day, but the history only shows the last run of the job. If I start the job manually it will keep the history until the next time it runs on the schedule. Anyone know what causes this? Is there a way to stop it so that it keeps the history? It would be nice to be able to look at more than one run of the job to see if there is a pattern to the failures...---------------------------Working until "the morning sun sets the midnight sky on fire"! |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-02-05 : 05:27:19
|
Right click SQL Server Agent and choose Properties.Then choose History Page.Now select how long you want to save history.
E 12°55'05.63"N 56°04'39.26" |
 |
|
|
GRAYWOLF
Posting Yak Master
106 Posts |
Posted - 2009-02-05 : 05:36:51
|
| Log size is set to 1000 rows and Rows per job is 100. ---------------------------Working until "the morning sun sets the midnight sky on fire"! |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-02-05 : 05:39:18
|
And how long is the history kept?
E 12°55'05.63"N 56°04'39.26" |
|
|
|
GRAYWOLF
Posting Yak Master
106 Posts |
Posted - 2009-02-05 : 05:42:49
|
| There is nothing set regarding time. It is set just the same as another server.---------------------------Working until "the morning sun sets the midnight sky on fire"! |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-02-05 : 05:49:35
|
I have a "Remove Agent History"...But you could increase your values to keep more records in joblog history.
E 12°55'05.63"N 56°04'39.26" |
|
|
|
GRAYWOLF
Posting Yak Master
106 Posts |
Posted - 2009-02-05 : 05:54:08
|
| Mine is "Automatically Remove Agent History" but it is not checked and the greyed out boxes say "older than: 4 weeks"---------------------------Working until "the morning sun sets the midnight sky on fire"! |
|
|
|
|
|
|
Lost Job History