MOM 2005 Datawarehousing Catchup

Total article views: 1203 | Views in the last 30 days: 14

 Rate this |   Join the discussion |  Briefcase

I wrote this script because our MOM Datawarehousing got so damn behind.
Every time the windows Scheduled task tried to run to warehouse the data
out of OnePoint, it would puke because the SQL log would fill up. This
allows you to start so many days out and it will increment it down by the number of days you specify and successively run the job over and over until it is completed
(down to the amount of days you specify) It's an "On Demand" SQL job, not something that
you would want to run all the time (obviously). The job will groom and
then re-partition the DB when it has caught up too which is nice. You
will want to disable the MOMX Partitioning and Grooming Job while this
one goes. With minor modification, you could use this to replace the windows scheduled task too and
run it only in SQL Agent. Makes life easier I think.

Total article views: 1203 | Views in the last 30 days: 14