SQL query to find out if your SCOM 2012 R2 Grooming jobs are succeeding

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.