no job history

sql2k sp3a
One of my servers doesnt retain very much job history. I have no history for
several jobs that run once or more per day. Is there a limit to the amount
of records the SysJobHistory table can hold? Any other ideas?
TIA, ChrisR
Yes, you can define the limit. EM, right-click Agent, Properties. On one of the tabs, you can set
this.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"ChrisR" <noemail@.bla.com> wrote in message news:evndYNpdFHA.2736@.TK2MSFTNGP12.phx.gbl...
> sql2k sp3a
> One of my servers doesnt retain very much job history. I have no history for several jobs that run
> once or more per day. Is there a limit to the amount of records the SysJobHistory table can hold?
> Any other ideas?
> TIA, ChrisR
>
|||Thanks Tibor.
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:%23EjtESpdFHA.1288@.tk2msftngp13.phx.gbl...
> Yes, you can define the limit. EM, right-click Agent, Properties. On one
> of the tabs, you can set this.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "ChrisR" <noemail@.bla.com> wrote in message
> news:evndYNpdFHA.2736@.TK2MSFTNGP12.phx.gbl...
>