SAP Knowledge Base Article - Preview

1736430 - SAP CCMS Cleanup Saplocks SQL Agent job is missing


You discovered that there is no SQL Agent job called "SAP CCMS Cleanup Saplocks" anymore even though it used to exists before.

You already followed SAP Note 547911 and used report MSSPROCS or transaction DBACockpit (SQL Script Maintenance / SQL Script Execution) to start all scripts, but this did not create the job.



  • SAP NetWeaver ABAP stack;
  • SAP Systems based on SAP NetWeaver ABAP;
  • MS SQL Server 2008 and higher;


SAP NetWeaver all versions


sap_cleanup_blockstats, CCMS_SID_SID_Cleanup_Saplocks, CCMS_SID_SID_Blocking_Lockstats, sap_insert_locks, DBACockpit, jobs , KBA , BC-DB-MSS-CCM , CCMS/Database Monitors for SQL Server , BC-DB-MSS , SQL Server in SAP NetWeaver Products , BW-SYS-DB-MSS , BW on Microsoft SQL Server , Product Enhancement

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.