MongoDB - where to find + change WF schedule state

Question

Hey all,

I have a couple of questions related to the MongoDB for 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?

Secondly, can I change the state of a schedule through MongoDB? I.e. How do I switch the state of a schedule from Enabled to Disabled and/or vice versa via MongoDB?

Cheers.

alexcassola · Answer

Best to have official confirmation on your question from someone within Alteryx.

In the meantime (to remain on topic) it is still not possible for me to enable/disable a schedule in an automated manner.

JonathanAllenby · Answer

Hey Alex - I appreciate taking the time to log back on for an update. I saw your last online time and thought it was a bit of a stretch to expect a response!

We thought that we could check the state using the Gallery API and MongoDB collection as well however the user with access to the MongoDB is telling us that the information isn't there and when we think we've found the relevant information it's actually something else.

Just to confirm, are you referring to this column when referring to the state of a schedule? :

We thought we found this after digging through the documentation for the Alteryx Service MongoDB schema: https://help.alteryx.com/20203/server/alteryxservice-mongodb-schema

This schema includes the collection AS_Schedules which contains the field "Status: (String) Schedule status." which seemed immensely promising but we've been told that "The “Status” field holds the current status of the schedule or workflow i.e. queued or running not the schedule state" by the user with access to the MongoDB."

We're currently waiting to see if Alteryx Support can confirm this, but if you're able to confirm/deny the location of the 'state' information as per the screenshot in the MongoDB/API it'd go a long way.

alexcassola · Answer

Hi Jonathan,

I still don't know of a way of enabling/disabling Gallery schedules in a batch 😑

You should be able to check the status of a schedule both from the Gallery API (/admin/v1/schedules/) as well as from your Gallery's MongoDB instance.