Job History Log overflow

Hi,
Maximum Job History Log size is set to 1000 and Maximum Job History Rows
Per Job is set to 100. There are some some jobs that are running every
minute. In less then five minute the Log Size grows to 45 from 0. So I guess
the jobs that are running every minute are filling up the History Log. When
other jobs that run once every night are not able to write in the History
Log. What should be the preferred setting in such scenario that will allow
the nightly jobs to write history in the History Log.
I can think of two options. I can either uncheck the Limit Size of Job
History Log option or change the value of the Maximum Job History Log Size
option. But then I don't know how large the History Log will grow. Can you
give me an idea on that? Also is there a way to automatically clear the
History Log?
Thanks in advance...You can set to the job history log size to unlimited. There are no known
issues associated with it -- though it might be a good idea to archive the
data from msdb..sysjobhistory for auditing purposes. Once you set a size
limit, the entire log rows outside the limit can be purged easily.
Anith|||> Also is there a way to automatically clear the History Log?
See sp_purge_jobhistory in BOL.
AMB
"helpful sql" wrote:

> Hi,
> Maximum Job History Log size is set to 1000 and Maximum Job History Row
s
> Per Job is set to 100. There are some some jobs that are running every
> minute. In less then five minute the Log Size grows to 45 from 0. So I gue
ss
> the jobs that are running every minute are filling up the History Log. Whe
n
> other jobs that run once every night are not able to write in the History
> Log. What should be the preferred setting in such scenario that will allow
> the nightly jobs to write history in the History Log.
> I can think of two options. I can either uncheck the Limit Size of Job
> History Log option or change the value of the Maximum Job History Log Size
> option. But then I don't know how large the History Log will grow. Can you
> give me an idea on that? Also is there a way to automatically clear the
> History Log?
> Thanks in advance...
>
>