Deleting Active Task

the first query will show you all active tasks… once you identify the task num, run the next two and it will clear it out.

select * from ice.SysTaskKill

update ice.SysTask
set EndedOn = GetDate(), TaskStatus = 'Complete', History = 1
where SysTaskNum = 442920

delete ice.SysTaskKill
where SysTaskNum = 442920
11 Likes