Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin. Search for scripts directly from SSMS, and instantly access any saved scripts in your SSC briefcase from the favorites tab.
Download now (direct download link)

MOM 2005 Datawarehousing Catchup

By Sean Gorman,

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: 1377 | Views in the last 30 days: 3
 
Related Articles
FORUM

String or binary data would be truncated.

String or binary data would be truncated.

FORUM

String or binary data would be truncated!!!

String or binary data would be truncated!!!

FORUM

String or binary data would be truncated.

String or binary data would be truncated.

ARTICLE

Would You Pay To Wear Jeans?

For this Friday, Andy Warren asks if you would pay to change your wardrobe for work.

ARTICLE

Would You Move For a Job?

Today we have a guest editorial from Andy Warren as Steve is on vacation. Would any job be enough fo...

Tags
miscellaneous    
 
Contribute