In this article
If users are unable to launch new or updated surveys, the production status of the system is pretty much at a standstill. The query below will return the number of Launch Survey tasks that have failed recently:
select count(distinct(td.projectid))
from taskinstance ti (nolock)
join taskdefinition td (nolock)
on ti.taskdefinitionid = td.id
where ti.tasktypeid=43
and ti.status not in (0,1,4)
and ti.starttime>dateadd(mi,-15,getdate());