Re-running a failed job in workbench using automation
We are currently using Domo Workbench to pull in data from various 3rd party property management information systems and this requires a large amount of jobs to be run. The problem comes when one job fails for one reason or another and there seems to be no way to automatically set it to rerun, causing someone to have to go in and manually restart the job.
Does anyone know of a way to set these jobs to run again if they run into an error and fail?
We are looking into how to use PowerShell and command lines to check every 30 minutes if a job has failed/ran into an error. This might be possible to do because every job that is run has a log file and within that a unique ID number for the job itself. If a job fails the word "error" is present throughout the log file so in theory you could use PowerShell to automatically parse through the most recent logs for "error" and then open workbench and restart any failed jobs. We need to look further into the capabilities of PowerShell as we are not very knowledgeable about the program but it is a potential solution that was brought up.
If anyone knows more about this topic or would be interested in collaborating on a solution please feel free to reach out.