Scheduling a Workbench Job which is event driven
Hi, I am a begginer when it comes to DOMO. I have a problem for which I want your ideas/solution.
I want schedule workbench job to run on the basis of an SQL Query result, is there any way by which I can handle the particular use case in the Workbench. Currently I see that we can schedule a workbench job manually or in a particular time.
Comments
-
You can run Workbench from the command line SEE HERE. So a solution for you would probably be to create some sort of script (command line, powershell, etc) which gets some result from the SQL Query and IF it meets your criteria then it would run the command via command line interface.
So on the Domo end you're just executing a command to run a workbench job via the command line, the connection to SQL and the logic behind when to execute the command would be on you to do, in whatever means you want.
I'm not a workbench expert but I don't believe you can do this in it natively, something like what I described above I believe would work.
**Make sure to like any users posts that helped you and accept the ones who solved your issue.**0
Categories
- 10.5K All Categories
- 8 Connect
- 918 Connectors
- 250 Workbench
- 470 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 477 Datasets
- 195 Visualize
- 253 Beast Mode
- 2.1K Charting
- 11 Variables
- 17 Automate
- 354 APIs & Domo Developer
- 89 Apps
- 3 Workflows
- 20 Predict
- 5 Jupyter Workspaces
- 15 R & Python Tiles
- 247 Distribute
- 63 Domo Everywhere
- 243 Scheduled Reports
- 21 Manage
- 42 Governance & Security
- 175 Product Ideas
- 1.2K Ideas Exchange
- 12 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive