ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
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.