topic MongoDB - where to find + change WF schedule state in Alteryx Server Discussions

MongoDB - where to find + change WF schedule state

alexcassola — Mon, 28 Jan 2019 10:08:20 GMT

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.

Re: MongoDB - where to find + change WF schedule state

WilliamR — Mon, 28 Jan 2019 12:54:58 GMT

Hello,

you can read this article, it can be a good starting point: https://community.alteryx.com/t5/Alteryx-Server-Knowledge-Base/Query-Scheduler-Database-from-Alteryx/ta-p/10534

Why want you to update scheduling status? Would it be easier to call the execution of your workflow through the Server API ?

Regards.

Re: MongoDB - where to find + change WF schedule state

alexcassola — Mon, 28 Jan 2019 13:10:42 GMT

Thanks. Bottom line is I would like to enable/disable multiple schedules on the Server in one go, rather than having to enable/disable schedules individually manually. (The server gallery hasn't got this facility unfortunately.)

I wasn't aware of the Server API option, so I'll look into whether there's an API for enabling/disabling schedules on the gallery.

I'd appreciated any further pointers/ideas on this if any :)

Re: MongoDB - where to find + change WF schedule state

JonathanAllenby — Wed, 14 Jul 2021 13:47:42 GMT

Hi Alex, just wanted to check in and see if you made any headway with this in the end.

Currently looking at the same challenge where we want to query the 'state' for scheduled workflows via the API, the MongoDB collection, or otherwise.

Re: MongoDB - where to find + change WF schedule state

alexcassola — Wed, 14 Jul 2021 16:37:22 GMT

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.

Re: MongoDB - where to find + change WF schedule state

JonathanAllenby — Sun, 18 Jul 2021 08:58:30 GMT

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.

Re: MongoDB - where to find + change WF schedule state

alexcassola — Mon, 19 Jul 2021 09:51:54 GMT

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.