Automatic history removal
I've been having a problem with SQL Server Agent, the log files are growing too big for the local partition. I know I need to put them on another non-critical partition and am in the process of getting there. However, if I can do the automatic removal after 1 week that would greatly reduce my problems. I went into SSMS and got into the properties for SQL Server Agent. Under the History section there is an option to automatically remove agent history. I checked the box and pressed ok. When I open the properties up to verify it, the box is unchecked. Any ideas on why it won't retain the automatic history removal?
Thanks in advance!
|