You had a DB issue (running out of space, for example), and due to that are seeing tasks stuck in Progress. How can the tasks be cancelled or resubmitted?
To cancel an in-progress task, go to View Submitted tasks...
Select and Click the in-progress task.
Click the box "Cancel this Task".
It will return with "Cancel Task...? Yes / No.
Note that not all in-progress tasks will successfully cancel--it depends on why/how they became stuck in-progress. In the above case, due to the DB issues, the tasks may have been corrupted.
Also, there is an option to resubmit in-progress tasks in Task Runtime Management > Resubmit Tasks.
Success of resubmission will also depend on the health of the in-progress task--not all in-progress tasks will resubmit successfully.
If the tasks do not cancel (or complete upon re-submission) they will remain in-progress and will display as such in View Submitted Tasks.