Share via

SCVMM: How to Remove Failed Jobs from the SCVMM Console

  • Article

By default, VMM is configured to maintain job history for 90 days.

Here is how to remove items from the job history manually (for example, failed jobs history) directly in the SQL Express for SCVMM 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

http://fawzi.files.wordpress.com/2009/10/1.jpg?w=600&h=414

4. Click New Query 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.

http://fawzi.files.wordpress.com/2009/10/2.jpg?w=600&h=402

6. When you re-open the SCVMM console, the failed jobs should not be listed.