Home > SCVMM, SCVMM R2, Tips&Tricks, Virtualization > Updated -VMM Tricks: Remove failed jobs from VMM console

Updated -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

SQL Management Console

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.

Delete Failed Jobs

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

Update: 8 Sep 2010

CAUTION!

Running this statement against the VMM db will cause TaskGC to no longer clean up jobs!

The command below, mentioned above, does not actually remove any jobs from the database. It merely causes them to not appear. This results in an ever increasing log of jobs that will not be correctly removed with TaskGC. One customer I worked with performed this operation and ended up with hundreds of thousands of jobs in the database. The highest number you would want is around ten thousand.

Do not use this command:

UPDATE tbl_TR_TaskTrail SET IsVisible = 0 WHERE TaskState = ‘Failed’;

The right way to clean up jobs:

SCVMM service may consume high memory or CPU utilization

http://blogs.technet.com/b/mbriggs/archive/2009/12/08/scvmm-service-may-consume-high-memory-or-cpu-utilization.aspx?wa=wsignin1.0

Advertisements
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: