Wednesday, October 28, 2009 6:54 PM
Fawzi
VMM Tricks: Remove failed jobs from VMM console
VMM maintains job history for the past 90 days.
If you want to remove them manually, we need take the following
steps to update directly in SQL DB. These steps are valid when you are
using SQL Express for VMM DB.
1. Download SQL Management Studio Express from the following link and install in SCVMM
http://www.microsoft.com/downloads/details.aspx?FamilyId=C243A5AE-4BD1-4E3D-94B8-5A0F62BF7796&displaylang=en
2. Open the management studio console and connect to <SCVMM server>\microsoft$vmm$
3. Select Databases > VirtualManagerDB

4. Click new query within the console and input the following command.
UPDATE tbl_TR_TaskTrail SET IsVisible = 0 WHERE TaskState = ‘Failed’
5. Click Execute, it will hide all the failed status job.

6. Now re-open the SCVMM console and the failed jobs should be invisible.