topic Re: Accessing the Alteryx scheduler AS_Schedules tabel in Alteryx Server Discussions

Accessing the Alteryx scheduler AS_Schedules tabel

MartWClimber — Mon, 28 Feb 2022 10:43:34 GMT

I'm trying to create some insight in when workflows are running and I need some information from the AS_Schedules tabel from the Alteryx scheduler DB (MongoDB).

I'm trying to find the database but I can not find it.

I found some topic's on how to access the MongoDB but those are not applicable to my situation.

https://help.alteryx.com/20213/server/primary-controller-configuration

https://community.alteryx.com/t5/Alteryx-Server-Knowledge-Base/Query-Scheduler-Database-from-Alteryx/ta-p/10534

Most examples got the button(see screenshot below) selected. (User-managed MongoDB).

We got the middle option selected (MongoDB)

is there a way to access the MongoDB database and or the AS_Schedules tabel?

Re: Accessing the Alteryx scheduler AS_Schedules tabel

jrgo — Mon, 28 Feb 2022 20:00:05 GMT

Hi @MartWClimber

I'd suggest downloading the Server Usage Report that's available from the download/licensing portal. You can learn how to interact with MongoDB by digging into the macros contained. Always use caution when interacting with this database as any changes, accidental or otherwise, could cause critical issues with your servers stability.

https://help.alteryx.com/20213/server/controller this is probably the documentation you should review to understand the settings your server is likely configured with. The first link you shared is describing how to use your own MongoDB instance vs. the self-managed/embedded instance (what you have now).

Re: Accessing the Alteryx scheduler AS_Schedules tabel

ArtApa — Mon, 28 Feb 2022 23:16:36 GMT

Hi @MartWClimber - If you use embedded MongoDB you can connect to your db directly using a MongoDB Input tool:

1) You need a MongoDB Input tool and a driver: https://help.alteryx.com/20214/designer/mongodb

2) You need to configure the tool as per below:

3) Enter "AlteryxService" as database and select AS_Schedules from the drop down list.

Hope that helps.

Re: Accessing the Alteryx scheduler AS_Schedules tabel

MartWClimber — Tue, 01 Mar 2022 08:09:44 GMT

With regards to the interacting part. I only need to read in some date from a specific table.

because it is a read action this should not cause any issues right?

Re: Accessing the Alteryx scheduler AS_Schedules tabel

ArtApa — Sat, 05 Mar 2022 19:52:43 GMT

Hi @MartWClimber - Yes, you will be fine. However, in the future you may want to consider Backups: https://community.alteryx.com/t5/Alteryx-Server-Knowledge-Base/Alteryx-Server-Backup-amp-Recovery-Part-1-Best-Practices/ta-p/22620