I have a job which was triggered 283000 times, and I am still trying to figure out how it happened. Before that, I am trying to delete those processes and I cannot. I cancelled the workflow recursively and tried to deactivate but it doesn't help. The tasks are in "Waiting for predecessor" and I cannot delete/cancel from the front end.
Is there a way I can delete all those jobs from the Database by running a query. If so it would be great if I can get the query.
We are in Automation Engine Version 12.0.2+hf.2.. Appreciate your inputs.