The current issue I have is with workflow system jobs.
I created a workflow called Lead Score, which scored my leads. The issue was I think I built the workflow wrong, so it never completed all the tasks and hung.
Anyway I noticed that it was creating loads of system jobs. 5000+ system jobs sometimes just on one lead. So the system must have 10s of thousands of jobs which was slowing the system.
I have tried deleting them, via the lead record, via the bulk delete, via other methods, but this did t work.
I tried pausing the workflow; I tried cancelling them, I tried loads of things but couldn't figure it out.
I've now deleted the workflow called Lead Score thinking that would remove the system jobs and fix it, but these system jobs remain.
The issue is, I cannot upload any new data i.e. upload XML new Accounts because the system was still saying waiting for resources.
I've checked Async Process on the Server, and that's working. I tried restarting Async process.
I tried running a script on the SQL to delete the workflow but for me, that was all new and a little scary not knowing what I was doing.
I can't seem to be able to remove these system jobs... So it frees up resources... So that's the current issue I need to solve.
I need this issue resolving asap.
I will grant access to my server using TeamView so that you can access the CRM server, SQL server, plus login to CRM as normal.