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
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 296 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 614 Datasets
- 2.2K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 729 Beast Mode
- 53 App Studio
- 40 Variables
- 677 Automate
- 173 Apps
- 451 APIs & Domo Developer
- 45 Workflows
- 8 DomoAI
- 34 Predict
- 14 Jupyter Workspaces
- 20 R & Python Tiles
- 394 Distribute
- 113 Domo Everywhere
- 275 Scheduled Reports
- 6 Software Integrations
- 121 Manage
- 118 Governance & Security
- Domo Community Gallery
- 32 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive