Missing sysjobhistory in sql job

Hi,
I have a sql2k job to do the log backup. For some reason, I don't see the
job history.
When it finish running I see the job history "completed sucessfully". Next
morning the history disappeared. I ran the trace over night and search
"%sysjobhistory%", I don't see any transactions that delete the records in
sysjobhistory table.
Don't know why? any ideas?
Thanks,.This is most likely caused by the settings on the "Job System" tab of the SQ
L
Server Agent Properties dialog box. The default setting is to retain 1000
rows total with 100 per job. If you have many jobs on the server and some of
them running frequently then the records for the job you are describing are
most likely being "pushed" out of the table due to the other volume.
Hope this is helpful.
--
David
"mecn" wrote:

> Hi,
> I have a sql2k job to do the log backup. For some reason, I don't see the
> job history.
> When it finish running I see the job history "completed sucessfully". Next
> morning the history disappeared. I ran the trace over night and search
> "%sysjobhistory%", I don't see any transactions that delete the records in
> sysjobhistory table.
> Don't know why? any ideas?
> Thanks,.
>
>|||David,
Thanks, I think that you are right. I'm going to increase the size to 2000
instead of 1000.
Thanks again,
"mecn" <mecn2002@.yahoo.com> wrote in message
news:%23hmBlapIGHA.3816@.TK2MSFTNGP12.phx.gbl...
> Hi,
> I have a sql2k job to do the log backup. For some reason, I don't see the
> job history.
> When it finish running I see the job history "completed sucessfully". Next
> morning the history disappeared. I ran the trace over night and search
> "%sysjobhistory%", I don't see any transactions that delete the records in
> sysjobhistory table.
> Don't know why? any ideas?
> Thanks,.
>