issue with history log settings

sql server 2000 sp3 -
this is very odd, we had a crash because the history log grew to big, and we
discovered it's not retaining the settings. the sql server agent, job
history log, if we check the options to clear the log set to 1000...
somewhere along the line that just mysteriously unchecks itself and the
history log just grews unabated. any advice?
David Bartosik - [MSFT MVP]
www.davidbartosik.comDavid,
Is it possible another DBA changed this setting in EM? I'm not aware of
this "automagically" changing. Perhaps SP4 would help. Until it is fixed
I'd recommend increasing the size of MSDB database (including monitoring
it's growth). You may also want to periodically perform:
SELECT COUNT(*) FROM MSDB..SYSJOBHISTORY
This can be automated with notification > value if needed.
HTH
Jerry
"David Bartosik [MSFT MVP]" <dbartosik@.community.nospam> wrote in messag
e
news:%23zJBKmPyFHA.3812@.TK2MSFTNGP09.phx.gbl...
> sql server 2000 sp3 -
> this is very odd, we had a crash because the history log grew to big, and
> we
> discovered it's not retaining the settings. the sql server agent, job
> history log, if we check the options to clear the log set to 1000...
> somewhere along the line that just mysteriously unchecks itself and the
> history log just grews unabated. any advice?
> David Bartosik - [MSFT MVP]
> www.davidbartosik.com
>|||Hello,
It sounds strange. You may need to make sure "Limit size of job history
log" option is checked. The "Maximum job history log size (rows)" option
specify the maximum job history log size, in rows. By default, it is 1000.
You may run sp_purge_jobhistory to purge jobhistory for a particular job.
Or you can run
DELETE FROM msdb.dbo.sysjobhistory
WHERE (job_id = @.job_id) and (run_date = @.run_date)
to delete job history.
I hope the information is helpful.
Sophie Guo
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
========================================
=============
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.