The currently running task reports shows tasks which have been running for many days or months. To change the task status from running to Failed or Completed, use the attached SQL statement. This will cause the tasks to drop off the Currently Running Task report.
There are multiple reasons a task might show as currently running but have timed out or stopped due to conflicts. For more information on task status issues, see HOWTO54534.
To change the task status from Running to Failed or Completed, see the below SQL query. The query searches for tasks that have been running longer than 7 days and changes the status to either 2 = Completed or 3 = Failed.
Prior to 7.6, use the following query:
declare @daysold int
set @daysold = 7 --Set number of days task has been running
update tis set InstanceStatus = 2 -- 2 = Completed, 3 = Failed
from TaskInstances ti
join TaskInstanceStatus tis on tis.TaskInstanceGuid = ti.TaskInstanceGuid
where tis.InstanceStatus in (1,4)
and datediff(dd, ti.StartTime, getdate()) >= @daysold
For 7.6 and later: