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?
Comments
-
<Deleted the original text on this reply> See next message - still can't get my .bat file with workbench calls to trigger properly from the CmdExec facility in the SQL Server Management Studio job agent. Hope the community can help me troubleshoot.
0 -
Still not working right. I am getting this error:
Executed as user: MNGDIRECT\anthony.garcia. C:\Windows\system32>cmd /C "C:\Program Files\Domo\Workbench\wb.exe" run-job --server mngdirect.domo.com --jobid 48Unable to connect to service. Make sure the service is running. C:\Windows\system32>cmd /C "C:\Program Files\Domo\Workbench\wb.exe" run-job --server mngdirect.domo.com --jobid 45Unable to connect to service. Make sure the service is running. Process Exit Code 0. The step succeeded.
Any ideas guys?
0
Categories
- 10.6K All Categories
- APAC User Group
- 12 Welcome
- 36 Domo News
- 9.6K Using Domo
- 1.9K Dataflows
- 2.4K Card Building
- 2.2K Ideas Exchange
- 1.2K Connectors
- 338 Workbench
- 250 Domo Best Practices
- 11 Domo Certification
- 460 Domo Developer
- 47 Domo Everywhere
- 100 Apps
- 703 New to Domo
- 84 Dojo
- Domopalooza
- 1.1K 日本支部
- 4 道場-日本支部へようこそ
- 22 お知らせ
- 62 Kowaza
- 295 仲間に相談
- 649 ひらめき共有