Agree that having only 10 per page is too limited. However, I currently monitor my recipes via Google Sheets using Workato Admin to trigger new failed jobs, then add details of the failed jobs to my sheet.
The new failed job trigger output does not include Job URL, so I set it up on my own. I would like to see Job URL being added to the output so that I will be able to manage errors from job reruns as well.
This seems like a pretty basic thing to have considering all of the hundreds of goodies that Workato already has! Really helpful for troubleshooting jobs when there's a problem or an issue that was caused by running a recipe.
How does one actually set this up?
Bryan Yap
Hi Mendy, in order to set this recipe up, you will need to do the following:
- Create a Google Sheet with the appropriate headers which Workato will then use to populate data into.
- Create a Workato recipe that is triggered by a `New failed job` via the `RecipeOps by Workato` connector. You can see an example recipe at, https://www.workato.com/recipes/630106-job-monitoring-to-google-sheets. Essentially, what the example recipe is doing is that it is detecting whenever there is a failed job and then populating it in a Google Sheets if the record does not already exist in the Google Sheet. Please look at the screenshot below for more information. As this is just an example recipe, you would probably want to modify it to better fit your needs.
Thank you very much. I'm trying to Test but it refused. So I skipped the test and started, no luck.
I created a Sheet in Google, copied all the column headers and updated your recipe. Then only thing I'm not sure of is JobID=JobID. Will continue trying.
Thank you!
I'll one up this idea. We have some jobs that I need to validate successful jobs. I can't do that today as I have to work through pages and pages of executions looking for a single job.
Still can't find your solution?
Send us a ticket, we will try our best to assist you with your problem
Derick Vogel
Exporting Job Report
Please add this feature ASAP to remedy this situation.
Thank you,
Elmer
6 people like this idea