SQL query to find out if your SCOM 2012 R2 Grooming jobs are succeeding:
- Grooming jobs are very important in SCOM.
- If grooming fails then your old data is not removed as per your grooming settings.
- This will cause your database to fillup and also cause slowness.
- You need to regularly monitor the Grooming jobs are will face a outage.
- Unfortunately, SCOM only raise alert if the grooming fails for atleast 6 days.
- So by this time depending on your environment there could be lot of issues and grooming could never be completd
- So i came up with SQL query which you can use to daily check after 6:00 AM server time
- "SELECT * FROM INTERNAJOBHISTORY ORDER BY INTERALJOBHISTORYID DESC"
- Run the above query and check if the grooming jobs succeeds. You should do this daily to avoid our OperationsManager Database gets filled.
