Command Line Workbench from the SQL Server Job Agent Scheduler
I am having a heck of a time getting a batch file of Workbench files to run in SQL Server Job Agent Scheduler. My batch file includes these 2 commands:
cmd /C "C:\Program Files\Domo\Workbench\wb.exe" run-job --server mngdirect.domo.com --jobid 48
cmd /C "C:\Program Files\Domo\Workbench\wb.exe" run-job --server mngdirect.domo.com --jobid 45
Normally, these 2 jobs take more than 30 minutes to run when I trigger the batch file manually through the command line.
When I run them through SQL Server Job Agent Scheduler through the CmdExec task, it runs and ends after less than 1 minute. It looks to me like nothing is happening but I am also not getting any errors in the history log.
My DBA helped me create a proxy profile so that the task runs as me.
Any ideas what I need to do to get this to work?
- 10.7K All Categories
- 13 Getting Started in the Community
- 41 Beastmode & Analytics
- 2.1K Data Platform & Data Science
- 59 Domo Everywhere
- 2.7K Charting
- 2.5K Ideas Exchange
- 1.3K Connectors
- 362 Workbench
- 303 Use Cases & Best Practices
- 503 APIs
- 120 Apps
- 48 News
- 754 Onboarding
- 1.2K 日本支部
- Private Company Board