SCSM Data WarehouseJob Status is running from 2 days after rebuild the old Data Warehouse

ResearchAli 1 Reputation point

At first, the issue was SCSM report did not come after some specific date. so we had tried to resolve that issue but the report was not there after some specific date.

so we decided to rebuild the old Data Warehouse and then we had follow bellow task

  1. unregister the old Data Warehouse
  2. remove the old Data Warehouse server
  3. configure a new server as a Data Warehouse with the same name and ip as like old Data Warehouse server
  4. successfully register the new Data Warehouse server

but after registering the new Data Warehouse the Data Warehouse job is stuck on running from 2 days and no report is their.

Note: as the SCSM Data retention period was long so all data was in SCSM operational databse.


Service Manager
Service Manager
A family of System Center products for managing incidents and problems.
199 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. XinGuo-MSFT 10,391 Reputation points


    Found a document which seemed helpful for our question, please refer to the link below.

    Troubleshoot stuck data warehouse jobs in System Center Service Manager

    0 comments No comments