In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Server Discussions

Find answers, ask questions, and share expertise about Alteryx Server.

Alteryx Mongo DB Jobs/schedule queries

Ariharan
11 - Bolide

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.? 

 

 

 

2 REPLIES 2
CatheyH
8 - Asteroid

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

 

ArtApa
Alteryx
Alteryx

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:

ArtApa_0-1647577553898.png