Skip to Content
Former Member
May 15, 2013 at 09:43 AM

Job SAP_*_MSSQL_COLLECTOR / sap_dbcoll endless running - error


Hi Experts,

i have a weird problem with job: SAP_*_MSSQL_COLLECTOR ( sap_dbcoll) on MS-SQL Server 2008, this job runs endless, with SAP ECC60/NW702 Kernel 720, DB-Release: 10.00.2531.

All other SQL-Server-Agent-Jobs are running without any problems.

Also the SAP Job SAP_COLLECTOR_FOR_PERFMONITOR is running endless and as a result of this behavier al batchjobs are occupied.

i tried to delete this job and recreated it with mssproc in se38, but whitout any effect.

, truncated the tables: sap_perfhist, sap_perfsample, sap_perfinfo, sap_mon_text -> no effect!

any idea or suggestion what i can do????

erromessage in sap system:

506 CL_SQL_STATEMENT==============CP 000 😎 Sequentielles Lesen Tunknown