How to check workbench job status from comand line

user063002

I need to check 1000 workbench jobs status, is there any way I can automate this ?

GrantSmith

You can utilize the command line utility to export all of your Workbench data sources to a folder as JSON objects.

'C:\Program Files\Domo\Workbench\Wb.exe' export-jobs -s YOUR_DOMO_URL -o OUTPUT_FOLDER

These JSON files will contain the last execution status under:

dataset["WorkbenchConfig"]["LastExecution"]["Success"]

This will be either true or false. You can use some scripting language to parse through the JSON files and check the status that way.

 

Here's a knowledge base to running Workbench from the command line for reference: https://knowledge.domo.com/Connect/Connecting_to_Data_Using_Workbench_5/03Running_Workbench_5#Running_Workbench_from_the_command_line