Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start 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.