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 |
|
¢ödêmån
Starting Member
32 Posts |
 Posted - 2002-07-04 : 01:07:49
|
| Does anyone know if there is a setting for job history in SQL Agent ?My jobs aren't keeping history for some reason ? Is there a limitation on the amount of jobs scheduled.Cheers--¢ödêmån-- |
|
|
byrmol
Shed Building SQL Farmer
1591 Posts |
Posted - 2002-07-04 : 01:22:22
|
| codeman,There is no limit to the amount of jobs scheduled (I think.. it would be limited to the size of an int or something...), only the number of rows in the log.Right click SQL Agent, goto to the Job System tab...DavidM"SQL-3 is an abomination.." |
 |
|
|
¢ödêmån
Starting Member
32 Posts |
Posted - 2002-07-04 : 08:23:52
|
| DavidM,Thanks.Amazing, how you dont get to play with some of these until you actually come to it.It would seem that we have lots of jobs and the history is being removed. I've bumped up the "Maximum job history log size (rows)"Will see if it makes a difference.Cheers,--¢ödêmån-- |
|
|
|
|
|
|
SYSJOBHISTORY