Alert: Data Warehouse event data dedicated maintenance process failed to perform maintenance operation Resolution state: New
Source: Data Warehouse Synchronization Service
Alert description: Data Warehouse event data dedicated maintenance process failed to perform maintenance operation.
Excepción ‘SqlException’: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
and If I open Microsoft SQL Server Management Studio and open database / Sql Server Agent/ Jobs / mdw_purge_data_[DatawareHouse] has errors, I try to launch with ‘Start Job at Step’ and appears this error:
Executed as user: CONTOSO\sqlsercluspro. Could not find stored procedure ‘core.sp_purge_data’. [SQLSTATE 42000] (Error 2812). The step failed.
¿Any idea of why can’t purge data correctly in SCOM DW ?