How to cancel a scheduled update from an ODBC connection?

Kyrsten

Hello! A previous co-worker of mine set up a schedule to update a third-party dataset on a weekly basis using an ODBC connection. Said third-party has now changed variable names and made various changes to the data structure, so I fear that the next data update will fail and dashboards will be left with no data until we can update the connection.

However — I'm not sure how to access the previous co-worker's ODBC set-up to cancel the schedule. Any tips? (I have no experience using an ODBC connection whatsoever, if that helps show where I'm currently at)

ArborRose

ODBC connection is in Windows > Administrator. There are two versions : 32 bit and 64 bit. You need to edit using the version that matches what was configured. If you don't find it in one, go to the other. Generally you want 64 bit for a 64 bit operating system. But sometimes compatibility leads to configuring in 32 bit.

Check each tab if you can't find it. But it's probably on the System DSN tab. That however, is just the ODBC connection. The schedule may have been set elsewhere like Task Scheduler. Check Task Scheduler to see if there is a scheduled task that looks like a Domo connection. There's no telling where the schedule was set. It might be in SQL jobs, or elsewhere depending upon what's calling the job.

As Colemen asked…have you checked to see if you have Domo Workbench on a machine? I agree with him - that is the first place I would look.

ColemenWilson

Do you, or someone on your team, have access to Workbench?

ArborRose

ODBC connection is in Windows > Administrator. There are two versions : 32 bit and 64 bit. You need to edit using the version that matches what was configured. If you don't find it in one, go to the other. Generally you want 64 bit for a 64 bit operating system. But sometimes compatibility leads to configuring in 32 bit.

Check each tab if you can't find it. But it's probably on the System DSN tab. That however, is just the ODBC connection. The schedule may have been set elsewhere like Task Scheduler. Check Task Scheduler to see if there is a scheduled task that looks like a Domo connection. There's no telling where the schedule was set. It might be in SQL jobs, or elsewhere depending upon what's calling the job.

As Colemen asked…have you checked to see if you have Domo Workbench on a machine? I agree with him - that is the first place I would look.

Kyrsten

Hi all, thanks for the feedback! Based on your comments, I figured step 0 was to get workbench for myself so I could set up a new data connection. The old data connection still exists, but thankfully it's not impacting anything for now (and there are enough changes that it warrants using a new connection anyway in this case). I'm able to view the schedule on my workbench, which confirmed that was the source. Long-term, I'll get the ownership for that switched over to me so I can make any appropriate changes.

For any lurkers — After downloading Workbench, this article helped me set up the data connection: https://domo-support.domo.com/s/article/360042932734?language=en_US