Scheduled job fails to run when DOMO dataset is deleted
I've set up a job in DOMO workbench to pull data from SQL Server and upload it to DOMO instance. Below are the details:
Job Details
Transport Type: MS SQL ODBC Data Provider
Reader Type: Database Query
DOMO Details
Dataset Name: test_schedule
Dataset Type: Workbench ODBC
I'm just using a normal select * from <table> as database query.
On the first execution, it runs fine and I can see data uploaded successfully in my DOMO instance.
But, if I delete this created dataset on DOMO and try to execute the job again, it fails.
My assumption was that it would recreate the deleted dataset on executing the job again.
Please let me know if I'm missing something or if any details are needed from my end.
Answers
-
@MichelleH Yes, I've set the update method to Replace.
Was trying to understand the behavior of workbench in case the dataset is deleted, while the job is scheduled.
0 -
@akki My understanding is that once a Workbench job is scheduled, then it needs a valid dataset destiantion. If the dataset is deleted, then it no longer knows where to load the data. The cleanest way to resolve it this issue is to rebuild to job since creating a job will also create a destination dataset in your Domo instance.
You should avoid deleting the dataset associated with a Workbench job if you plan on using the job again because of this. Setting the update method to Replace BEFORE deleting the dataset allows you to overwrite the data in the existing dataset instead of having to delete it.
0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 297 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
- 678 Automate
- 173 Apps
- 451 APIs & Domo Developer
- 46 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