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