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