Welcome @Raghini_Rajaram
I’m taking a look at your account and will report back once done, but wanted to explain quickly about how this works.
A scheduled job goes through a few stages (as you know I’m sure, but let’s put the details for whoever may read this later). The gray state is when a job is staged, then yellow for the execution runtime, and finally green or red depending on what happened at runtime. FAQ: Understanding job statuses
Canceling a job
If the dataset is still gray, then deleting/purging it will aborted the process immediately, because all of the actions for this queuing step are available and local to the Galaxy database.
If a dataset is yellow, and is executing the tool, then deleting/purging is itself a sort of staged process. Why? Jobs are dispatched to cluster nodes to run. There isn’t any communication between that cluster node and the database until the job arrives back, to deliver the results or to update about a failure. Attempting to force a cluster node to abort, with manual ad-hoc intervention, is something we avoid, even for our own jobs!
What about workflows? When jobs processed together in a workflow, if the upstream job failed (the input for a tool) then the downstream job will be paused (blue dataset). Once that happens you can delete/purge those datasets too.
What to do
If you ran a workflow (and sent the output to a new history, which should be the case most of the time), you can purge the entire output history, since this is faster and catches “all” the jobs associated with a workflow run together. For individual jobs, you could think about copying datasets to a new history, then purging the original history. This doesn’t make the process happen faster, since the communications are always based on the dataset status, but it can be a useful fast way to get rid of larger batches of work.
I’m going to check your account to see what is going on, however the general advice is to delete what you do not want anymore, queue up the replacements, then allow the scheduling system to manage the throughput for you.
More soon! 