This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
General Discussions has some can't miss conversations going on right now! From conversations about automation to sharing your favorite Alteryx memes, there's something for everyone. Make it part of your community routine!
Hi All,
I am trying to figure out an idle time on our Alteryx Server for scheduling a Backup and Restore.
Sometimes for windows upgrade also we need to restart the server and I want to do it during as idle time.
Our Server has more than 100+ Artisians and 270+ Schedules. And in the Jobs "Scheduled Workflows" tab it doesn't allow us to do any export neither I could find any documentation wherein I could get this information from the Alteryx Server Database.
Can someone help me, please? I need this urgently as I have to schedule a restart for the Windows upgrade.
Thanks
Subhojit
Solved! Go to Solution.
Hi @isubho , take a look at this community page: https://community.alteryx.com/t5/Alteryx-Server-Knowledge-Base/Query-Scheduler-Database-from-Alteryx...
Might give you pointers and solution for the information you are looking to gather. Hope this helps!
Thanks @AbhilashR this really helps.
But I am trying to find one more information i.e. frequency of the schedules. I have attached the screenshot of what I am trying to find.
Can you help me find the frequency of all scheduled application?
Thanks
Subhojit
@isubho The Server API can provided extended details on existing schedules. The API response does include the frequency of the schedule along with other details that aren't easy to retrieve directly from the database. This API endpoint does require admin/curator access though. You can find the documentation on your local Server by navigating to the API Documentation (Log into your Server. Top right if the screen find the help (?) icon. Hover and select API Documentation). You can also review this documentation online via the following link:
https://gallery.alteryx.com/api-docs/#!/admin-workflows.json/GetPagedSchedulesGET