SAP Knowledge Base Article - Preview

2243300 - Cannot activate SQL Server Agent 'Remove agent history'

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.

KBA1.PNG

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 , 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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.