Symptom
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.
Read more...
Environment
- Microsoft SQL Server 2005 and Higher
- SAP NetWeaver based systems running on Windows and SQL Server
Keywords
SQL Server Management Studio, SQL Server Agent, REMOVE AGENT HISTORY, SAP CCMS Check Database SID, SAP CCMS_sid_SID_Update_Tabstats, SAP CCMS Check Database , KBA , BC-DB-MSS , SQL Server in SAP NetWeaver Products , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.