Free Trial

Alteryx Server Discussions

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

Where the "Scheduled is enabled" information stored in MongoDB (Server 2023.1)

PeterPerera
8 - Asteroid

Hi

 

In AlteryxService MongoDB Schema

 

In AS_Schedules schema

 

2024.2 :  has Enabled: (Boolean) Whether the schedule is enabled to run.

 

https://help.alteryx.com/current/en/server/configure/database-management/mongodb-management/mongodb-...

 

2023.1 : Does not have such Enabled flag.

 

https://help.alteryx.com/20231/en/server/configure/mongodb-management/mongodb-schema-reference/alter...

 

However we can disable the schedule as shown below. I am wondering , In 2023.1 , where does the MongoDB keep the info when I disable or enable the schedule (Which schema and what table?)

 

                                               

PeterPerera_0-1731086593633.png

 

Thank you

 

2 REPLIES 2
patrick_digan
17 - Castor
17 - Castor

@PeterPerera For 23.1, I would assume that info is stored in the field called __ServiceData in the AS_Schedules table. That data is in a blob format, and one way to convert the field to something readable in alteryx is to use the service data parser macro from alteryx. I've included a copy of the macro in this post: https://community.alteryx.com/t5/Alteryx-Server-Discussions/ServiceDataParser-macro-for-2023-2/td-p/...

 

 

PeterPerera
8 - Asteroid

Thanks Patrick for the quick reply. I will check this solution.