EREs DREs and SQL Jobs
Hi, So there are powershell scripts to removed orphaned EREs and DREs. Does the FIM_DeleteExpiredSystemObjectsJob clean these up too? If not, how have people automated this process? Regards, SK
May 18th, 2012 12:55am

That one doesn't no - however if you have installed FIM 2010 Update 2 (http://support.microsoft.com/kb/2520954) there is a new stored procedure that will do the trick DeleteOrphanedRulesByType. From the link above under the heading Fixed issues in FIM Service (Issue 4)- there is an explanation of the procedure and how to use it. Andrew.
Free Windows Admin Tool Kit Click here and download it now
May 18th, 2012 1:34am

Thank you, how do I turn these into something that will run and execute say once a week?
May 18th, 2012 1:59am

Create a SQL Agent job to execute the SP and have it run as often as desired.Frank C. Drewes III - Senior Consultant: Oxford Computer Group
Free Windows Admin Tool Kit Click here and download it now
May 18th, 2012 3:01pm

Create a SQL Agent job to execute the SP and have it run as often as desired.Frank C. Drewes III - Senior Consultant: Oxford Computer Group
May 18th, 2012 3:06pm

Thank you - what would be a recommended schedule for clearing EREs and DREs? once a week? once a month?
Free Windows Admin Tool Kit Click here and download it now
May 22nd, 2012 7:43pm

There is no recommended schedule. Ideally, you shouldn't have to worry about them at all. Orphaned can be an indicator for a design issue - unless, you know where you are generating them and you are accepting the fact that your design generates them. Cheers, Markus Markus Vilcinskas, Knowledge Engineer, Microsoft Corporation
May 31st, 2012 8:47pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics