CCMS Cleanup Saplocks - Missing stored procedure

[Former Member]

Hi,

I'm getting an error on this Job on the SQL Server Agent

"Executed as user: <SID>adm. Could not find stored procedure 'sap_cleanup_blockstats'. [SQLSTATE 42000] (Error 2812). The step failed."

I've searched on service marketplace and in SDN and the only referenece is in SAP Note Number: 547911 - SAP CCMS Blocking Lockstats where it says that the job is set running report MSSPROCS, but if you only have the java part of Netweaver installed how can set this job or how can get the stored procedure.

Rgds,

[Matt_Fraser]

Hi Ignacio,

I'm pretty sure that SQL Agent job only applies to ABAP systems, and/or to the SAPMonitor schema that you may have in your database if you've set up all the Solution Manager monitoring.  So, I think you can safely disable it.

Regards,

Matt

[Matt_Fraser]

Oh... just noticed this question was six years old.

[Former Member]

LOL.  Ya, I knew it was old but it had no answer.  I wanted to post what I found that worked for me...

[Former Member]

Hi Ignacio-

I found I had this similar issue and found the solution in SAP note 1736430.

Hope this helps someone...

-Nathan