Resources For IT Professionals
Post an article
Wikis - Page Details
Options
RSSSubscribe to Article (RSS)
Can You Improve This Article?
Positively! Click Sign In to add the tip, solution, correction or comment that will help other users.

Report inappropriate content using these instructions.
Wiki  >  TechNet Articles  >  SCVMM: How to Remove Failed Jobs from the SCVMM Console

SCVMM: How to Remove Failed Jobs from the SCVMM Console

SCVMM: How to Remove Failed Jobs from the SCVMM Console

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

SQL Management Console

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.

Delete Failed Jobs

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

, , , , , , , , , , , , [Edit tags]
Leave a Comment
  • Please add 8 and 3 and type the answer here:
  • Post
Wiki - Revision Comment List(Revision Comment)
Sort by: Published Date | Most Recent | Most Useful
Comments
  • 8 Aug 2011 2:15 PM

    tonysoper_MSFT edited Revision 4. Comment: reverting demo changes

  • 5 May 2010 10:16 AM

    Tony Soper_MSFT edited Original. Comment: Adding how to and product name to title

Page 1 of 1 (2 items)
Wikis - Comment List
Sort by: Published Date | Most Recent | Most Useful
Posting comments is temporarily disabled until 10:00am PST on Saturday, December 14th. Thank you for your patience.
Comments
  • Posted by
    on 5 May 2010 10:16 AM

    Tony Soper_MSFT edited Original. Comment: Adding how to and product name to title

  • Posted by
    on 22 May 2010 8:37 AM

    This article was created by user Mohamed May 3, 2010. There is a TNWIKI bug currently under investigation that for some reason changes listed ownership. I will update when this bug is fixed.

  • Posted by
    on 8 Aug 2011 2:15 PM

    tonysoper_MSFT edited Revision 4. Comment: reverting demo changes

  • Posted by
    on 9 Aug 2011 2:17 AM

    :D

  • Posted by
    on 30 Aug 2012 1:51 PM

    Yes, I face this one time, thanks for sharing!

  • Posted by
    on 31 Aug 2012 11:39 AM

    Happy to see this is useful

Page 1 of 1 (6 items)