I need to check 1000 workbench jobs status, is there any way I can automate this ?
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:
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