How to cancel a scheduled update from an ODBC connection?

Options

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)

Tagged:

Best Answer

  • ArborRose
    ArborRose Coach
    edited July 2 Answer ✓
    Options

    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.

    ** Was this post helpful? Click Agree or Like below. **
    ** Did this solve your problem? Accept it as a solution! **

Answers

  • ColemenWilson
    Options

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

    If I solved your problem, please select "yes" above

  • ArborRose
    ArborRose Coach
    edited July 2 Answer ✓
    Options

    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.

    ** Was this post helpful? Click Agree or Like below. **
    ** Did this solve your problem? Accept it as a solution! **

  • Kyrsten
    Kyrsten Member
    Options

    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