In order to remove job history older than 4 weeks, for example, job SAP CCMS Check Database SID, 'Remove Agent History' setting in SQL Agent job is enabled.
SQL Server Management Studio --> SQL Server Agent Properties --> history--> enabling 'Remove Agent History' older then 4 weeks-->click OK.
However, the change of 'Remove Agent History' setting cannnot be saved, and it goes back to the default value, which is 4 weeks.
- Microsoft SQL Server 2005 and Higher;
- SAP NetWeaver based systems running on Windows and SQL Server.
SQL Server Management Studio, SQL Server Agent, REMOVE AGENT HISTORY, SAP CCMS Check Database SID, SAP CCMS_sid_SID_Update_Tabstats , KBA , BC-DB-MSS , SQL Server in SAP NetWeaver Products , Problem
About this pageThis is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).
Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.