topic Tasks per Jobs as a KPI? in Workato Pros Discussion Board

Tasks per Jobs as a KPI?

jblanchett — Tue, 27 Dec 2022 19:09:09 GMT

Does anyone set target zones for task to job ratios? I'm wondering if this is a useful metric to track. On one side, if jobs > tasks, that means that many jobs are running, but performing no work. On the other hand, a high tasks/jobs ratio could indicate monolithic recipes, but are more likely to indicate high volume jobs processing individual records within a for each loop. Therefore, I'm thinking the higher the tasks/job the better, as long as you can address monolithic recipes somehow.

Curious to hear other folks thoughts!

Re: Tasks per Jobs as a KPI?

meghan-legaspi — Tue, 03 Jan 2023 15:57:30 GMT

Hey @jblanchett - any updates on this process and how it has or hasn't worked for you? Curious to hear an update!

Please let me know if you would like assistance getting in touch with someone on the Workato team for more insights on this.

Thank you,
Meghan

Re: Tasks per Jobs as a KPI?

jblanchett — Wed, 18 Jan 2023 03:48:29 GMT

Hi @meghan-legaspi no info on this yet, no! If someone from Workato has any recommendations, I'd love to hear them. I'd like to formalize some "Workato Platform Health" metrics and thinking jobs, tasks, errors, and the relationships (ratios) between them should be useful somehow.

Re: Tasks per Jobs as a KPI?

meghan-legaspi — Wed, 18 Jan 2023 22:27:57 GMT

After digging into this a bit, I've learned that funnily enough, we’ve been working on Platform Health KPI-type updates! While I don't have much more info than that at the moment, I'd love to hear other people's thoughts on the topic.

Please feel free to keep in touch your Workato rep for updates, and I'll be sure to update you here when I have more info for you. 🙂

Cheers!
Meghan

Re: Tasks per Jobs as a KPI?

mppowe — Thu, 19 Jan 2023 13:38:27 GMT

In a review with Workato, they said they like to see jobs using less than 10 tasks per execution as a general rule of thumb. That's also assuming that these recipes are trigger-based and being executed frequently throughout the day. Obviously, if this is a batch job that just runs once per day, that guideline would change. I'd like to get the point where we have a sense for how many tasks we're consuming from each recipe or project, then as new integration requests come in we could estimate the task usage and make a decision based on the cost/benefit analysis and how many tasks we have remaining.

But... we're not even close to that. We've had some conversations with Workato about some tooling in that area.

Re: Tasks per Jobs as a KPI?

jblanchett — Fri, 20 Jan 2023 05:04:41 GMT

Thanks @mppowe ! 10 seems low, but maybe a good guideline for "steps" - not including for each loop executions.

Re: Tasks per Jobs as a KPI?

mroldanvega — Thu, 26 Jan 2023 00:53:22 GMT

10 seems very low to me as well.

@jblanchett how are you mining the data? As part of an ongoing project I am trying to identify recipes that have jobs but have less than normal (or none) tasks, so I was just curious.

Re: Tasks per Jobs as a KPI?

MItoiz — Wed, 13 Sep 2023 14:49:38 GMT

Same here !
I'll try to define some monitoring KPis on our recipes to have on overview on the number of tasks, type of errors....