Limit size of job history log

[JayKusch]

Is there a way to Disable the ""limit size of job history log" besides going thru Enterprise Manager.

I am looking for a way to do this via a command or stored procedure.

Thanks

J. Kusch

 

[clapag22]

That info is stored in the registry. I guess you could use xp_regwrite to turn it off/on.

If you look at sp_jobhistory_row_limiter in MSDB you can see how it uses xp_regread to determine the status.

 

[JayKusch]

Is "sp_jobhistory_row_limiter" the correct name for the SP? I have looked in BOL as well as Googled it with no luck.

I did get a hit on "xp_regwrite" to get me started.

Thanks

J. Kusch

 

[clapag22]

Yes. Just confirmed that's the name. I confirmed that there's not much out there when doing a search, either.

The only thing I found was an install script at:

http://www.cis.southalabama.edu/share/New Folder/Microsoft SQL Server/MSSQL/Install/instmsdb.sql

And a mention of it on a google group (as part of a script - no info you'd want):

http://groups.google.com/groups?selm=O$p8msj4BHA.2312@tkmsftngp04&oe=UTF-8&output=gplain