topic Re: Query Alteryx Database for workflow execution in Alteryx Server Discussions

Query Alteryx Database for workflow execution

Zimo — Tue, 17 Dec 2019 20:39:07 GMT

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.

Re: Query Alteryx Database for workflow execution

BrianR — Tue, 17 Dec 2019 22:27:24 GMT

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.

Re: Query Alteryx Database for workflow execution

Zimo — Tue, 17 Dec 2019 22:33:01 GMT

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.

Re: Query Alteryx Database for workflow execution

BrianR — Tue, 17 Dec 2019 23:00:35 GMT

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.

Re: Query Alteryx Database for workflow execution

Zimo — Tue, 17 Dec 2019 23:06:33 GMT

Thanks Brian, that would work but not exactly I am looking for. I am more leaning toward some kind of database access rather than API. But I will try that out. thanks a lot.

Re: Query Alteryx Database for workflow execution

BrianR — Wed, 18 Dec 2019 01:27:34 GMT

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.

Re: Query Alteryx Database for workflow execution

Zimo — Wed, 18 Dec 2019 16:59:36 GMT

Really appreciate your help! This is exactly what I am looking for!