Blog site to provide a quick way to find solutions on problems encountered during a day to day work. Some articles are just copies of KB or Forums, but they might come in handy.
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