Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

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.