Collecting the exact same MOM 2005 daily stats everyday problem

We ran into this problem a few weeks ago. For a little more than a week our MOM 2005 daily statistics that were being collected nightly were the exact same. I found this a bit strange so I ran the stat collection in the morning which gave the same results. 

After a bit of digging I found that several key SQL Jobs for the OnePoint database were no longer running as they were scheduled to be running. It seems that the last round of patching stopped the SQL Jobs from running on their proper schedule. (Patching took place right after the last time the SQL Jobs ran) Once I got the three SQL jobs that start with "OnePoint - TodayStatisticsUpdate*" the statistics started updating as expected.

 

 

Comments

No Comments