12 December 2013

NSE queue fills up with orphaned power on jobs.

Fix orphaned RTCI tasks using the following SQL: insert into ItemToDelete select distinct i.Guid, GETDATE () from Item i join ItemClass ic on ic.Guid = i.Guid join Class c on c.Guid = ic.ClassGuid left join ItemReference ir on ir.ChildItemGuid = i.Guid and ir.Hint = 'taskschedulehint' where ic.ClassGuid = 'A03EFF6B-B41B-4BD5-8D48-3980B23AE8D7E' and Attributes & 1 = 1 and ir.ParentItemGuid is null group by i.Name, ir.Hint order by i.Name Ref : http://www.symantec.com/business/support/index?page=content&id=TECH212717