DataWarehouse has got some invalid information? Re-run jobs?


  • We have created a report to show active Activities on Change requests. In the main database all Activities are Completed on CR3246, but in the DataWarehouse a few Activities are still InProgress on CR3246. This CR3246 is completed 10 days ago, but it looks like the synch job has missed it.

    How can I Re-Run the datawarehouse job, to sync the missed activity statuses?

    Is there any way of parametering the Extract job, to go back in time for 4 months and check for changes?
    • Edited by Dan_MS Monday, February 27, 2012 3:16 PM
    Monday, February 27, 2012 12:41 PM

All replies

  • There are no parameters that I am aware of to allow jobs to run for WI of a specific time period.  If you download SMLets powershell tools for service manager you can run and monitor DW job status.  If there is a problem running the jobs you should see it there.

    Allen Anderson Systems Analyst Arizona State University - OKED Knowledge Informatics

    Wednesday, February 29, 2012 3:10 PM
  • I believe Allen is correct, there is no way to make the DW transfer old data. However, this feature is, in my opinion, urgently required.

    For example, you create a Management Pack to transfer your incident logs to the DW. Only newly created logs and relationships created after this change appear in the DW. All exisiting data is lost during grooming, which is not good.

    Wednesday, February 29, 2012 8:05 PM