Share via

SCSM Data Warehouse - Force Complete Stuck Job and Run New Job

  • Article

https://support.microsoft.com/en-ca/help/4040022/troubleshooting-hung-data-warehouse-job-in-service-manager

Steps:

1)      Set Bad Job to Completed:

ü  Get-SCDWJob - find job and copy BatchId

ü  Open DWStagingAndConfig and run command:

UPDATE Infra.WorkItem SET StatusId = 6 WHERE BatchId = '<BatchId>'

2)      Get new job modules for job

ü  Open DWStagingAndConfig and run the command:

EXEC Infra.CreateBatch '<JobName>'

Ex.

EXEC DWStagingAndConfig.Infra.CreateBatch 'Process.SystemCenterChangeAndActivityManagementCube'