Query Alteryx Database for workflow execution

Hi Alteryx Gurus,

I need to get access to when a certain job is executed on the Alteryx Server, so I am wondering if there is a way to query Alteryx Server database for this matter, also would be great if there is resource about the data schema adopted.

Regards,

Zimo.

Developer Tools

Reporting

Server

MongoDB

Events

Accepted answers

BrianR

Take a look at the Alteryx Gallery API (the url will be http://<yourserverurl>/gallery/api-docs/#admin) - you should be able to capture the status of a given job, and the API results will indicate the Status, and disposition (i.e., Running, Completed, and whether or not the job was Successful or not). I believe that might be what you are looking for.

BrianR

In addition, take a read through this post, it discusses a bit about the schema, and also a recommendation on that Server Usage Report as a guide to get started with querying MongoDB.

All comments

BrianR

Hi - if you are looking to see the status of a job (scheduled workflow), if you are a Curator, you can log on to the Server Admin portal and view the Jobs tab - That should show you all active jobs, and when they are scheduled for execution. Also, check out the Server Usage Report - you can download this from the download portal...that workflow will allow you to look at this information over a certain period, such as last 30 days.

Zimo

Hi - thanks for the input, I don't know those access actually, I am pretty new to Alteryx. However, I am looking for something more systematic, I need to figure out a way to query Alteryx database to know at a given time whether a certain job is executed or not, and based on the latest run time, I will do stuff differently in other systems. Does that make sense toy you? Does Alteryx have the ability to support this task?

Thanks,

Zimo.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703