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.