topic Re: Alteryx Mongo DB Jobs/schedule queries in Alteryx Server Discussions

Alteryx Mongo DB Jobs/schedule queries

Ariharan — Tue, 15 Mar 2022 21:07:45 GMT

Hey all,

I have a couple of questions related to MongoDB for the Alteryx Server.

Where can I find what the state of a scheduled Workflow is from within the server’s MongoDB instance? I.e. How can I find out whether a schedule is enabled or disabled just by querying the MongoDB?

How can I map the scheduled/queued workflow databases with the user's table? I have checked on the Alteryx Service As_Queue and AS_Schedule tables and they don't contain any user information like (Username, Role, Email, etc.).I tried to join the AlteryxGallery users table but I couldn't find the common field for that.

Is there any way to identify the details of the job which is running for more than 2 hours.?

Re: Alteryx Mongo DB Jobs/schedule queries

CatheyH — Wed, 16 Mar 2022 16:39:22 GMT

Your last question (and possibly the others too) can be answered by the Alteryx Server Usage Report I think https://help.alteryx.com/20212/server/install-server-usage-report

Re: Alteryx Mongo DB Jobs/schedule queries

ArtApa — Fri, 18 Mar 2022 04:26:03 GMT

Hi @Ariharan - In addition to the Server Usage report I recommend you to try APIs. I believe the one below will provide you with all answers on your schedules questions: