I've seen various solutions/workarounds but this seems to be a table-stakes ask? When scheduling a workflow I should be able to specify which parameter values to run with. Just two of many use case examples -
Use case #1 - a single analytic app could be scheduled multiple times, each schedule specifying a different line of business
Use case #2 - credentials, allow the user to schedule a workflow with their saved credentials. When their credentials change all they would have to do is update the schedule parameters
(If you know a better way I'm all ears, not the API thought that isn't a bad way to do it, just not super Easy)
I would like to see the enhancement of being able to schedule a start and stop time for specific jobs that need to run multiple times per day, so they don't run during the nightly backup periods of the Alteryx server. This can cause the daily backups of the Alteryx Gallery to fail. Currently SQL Server Management Studio/SQL Server has the function to able to schedule start and stop times for specific job. Currently Scheduler page on Alteryx Gallery/Server lacks this feature.
SQL Server Management Studio
Schedules on Alteryx Gallery/Server
For scheduled jobs, there should be an option to include performance profiling in output logs globally. Basically we are looking at how we can understand which custom macros are in use, and in which workflows, and one way to do this would be to get the output logs into another tool (i.e., splunk), and then set up some queries there. It would work, but I would have to tell N developers to go set performance profiling on, re-upload their workflows, ect.
But why not have a switch on server / gallery that just turns this feature on globally for every scheduled workflow?
Thank you for attending my TED talk on why performance profiling should have an option to be set globally.
*This is an idea from @cneivam from the Portuguese Community*
As the Server Admin I'd like to have the ability to view ALL "Workflow Results" for all Subscriptions.This will give the highest level admin the ability to monitor all schedules (on the entire server instance) and monitor if they are unable to complete successfully (example- unable to allocate memory) and any other errors are occurring.
Knowing this information will help the server administrator understand if there are issues with the server itself (e.g. if we need more workers or to simply adjust actual server system settings..etc..)
For whatever reason a schedule is disabled, whether a Studio expires, or for any other legitimate reason, a notification email should be sent to the Admin and the one that created the schedule in advance of it being disabled. When a scheduled workflow is not executed, it leaves us scrambling for answers. A sudden disablement of the schedule is disappointing to discover after all other stones have been turned. Notify us in advance of a schedule being disabled.
Currently when scheduling workflows, there is an option to schedule based on the calendar day but not on business day. For example, if I want to run a workflow on Business Day 1 of every month, it is not necessarily the first day of every Month. For the month of June 2019, Business Day 1 is June 3rd, since the 1st and 2nd fall on the weekend. Many departments run their processes on Business Days rather than Calendar days. Also factoring Holidays into consideration would be a plus since January 1st for example is a Holiday, Business Day 1 would fall on the 2nd.
It will be great to make visibility of workflow execution results to other users in same subscription.
As of now, only schedules are visible to all users in a subscription, but not the workflow execution results executed by a user to other users in same subscription.
This will avoid duplicate execution of same workflow by multiple user in a team as it will provide option to cross check the execution results by other users, if executed already, before execution of same workflow.
I really want to see this feature in new versions. Its frustrating the lack of options we have with scheduling workflows on the server. I need to have my process run every 10 mins but only on certain days and in certain time windows. Creating a schedule for this is impossible unless I manually create hundreds of schedules.
I have a few workflows that I have hosted on out Gallery Server and I have them scheduled.
Ex: Process A is scheduled to run every 10 mins Mon – Sunday.
Problem: I only need Process A to run Every 10 Mins on Mon – Sat from 2 AM to 6 PM
Currently there is not a scheduling configurations that allow this type of schedule. How can I get my workflow to run every 10 mins but only during certain times and on certain dates?
Now, under the Job Tab, it is only show the status of running job.
Suggest to add one new page for showing the run history of each workflow/job.
1. Workflow name
3. Assigned Worker
4. Start time
5. End time
8. Job Type (schedule or manual tracker)
10. Message ( e.g. error log)
Below you can see few of my suggestion to improve Alteryx Server.
Idea for Alteryx Server monitoring:
Give server more functionality with:
Hopefully you will find these suggestions interesting and useful.
Use case: I need to schedule a workflow to run every 2 hours each day, with the first run at 7am and the last run at 7pm
Current solution: I need to create seven daily schedules for each hour that i need the workflow to run
Idea: Add an intraday "Start Time" and "Stop Time", or "Between" to the "Minutes / Hours" schedule type, so i can create one schedule that meets the use case requirements
Example schedule with new parameters that meets use case requirements:
Start Time = 7:00 AM
Stop Time = 7:00 PM
Repeat Every = 2 hours
Start Time could default to 12:00 AM
Stop Time could default to 11:59 PM
Currently, this is completely manual with whoever is assuming the schedule creating it under their profile and then the old schedule being deleted.
This can happen often in organization where a user leaves the company or assumes a new role requiring some else to maintain those schedules. It would be convenient if there was an option to reassign the owner of a schedule to simply this process.
In order for us to manage the large number of canvasses on our server - we need to add the ability for Admin teams to require additional attributes on every canvas:
For us, these mandatory attributes would be:
- Which team do you belong to (dropdown)
- What business process does this serve (dropdown - multiselect)
- Primary & secondary canvas owner (validated kerberos)
For the ones that have dropdown lists - we can provide the master data into a drop location or into a manually configured list on the server.
With Version 2018.3, you removed the Autodetect SMTP button, and with it, have rendered the Email Tool virtually useless for many people, which is a shame because it is a critical tool for some of us to share reports produced in Alteryx.
In requiring an SMTP path, there are a host of authentication issues that need to be addressed, and we can't seem to figure out how to configure the path and From emails properly to allow the tool to work without errors.
My only solution at this point is to rollback to 2018.2 so I can continue to use the Email tool.
Please address this so we can use the tool as before, or provide the necessary configuration options to allow for proper authentication with popular email services (Gmail, etc.)
We have more clients that would like to prioritize their scheduled jobs based on run time and importance.
It could be a simple priority number, that decides which job that need to run next. Further it could be nice to be able to allocate certain workers to certain jobs.
I am looking forward to your feedback.
Currently if there is a password change, I have to download my workflows, update the password in the Tableau connector, and reupload the files.
This would enable groups with a single sign on to ensure scheduled workflows are not interrupted.
I'm liking the new ability to change the permission for users to schedule, prioritize and assign their work.
I would also like the Permissions to not show if I've turned it off. For most users this feature will not be available and showing a feature they won't be able to use will cause more problems then answers.
Just like in the notification tab, I would like the features that are off not show up in the end users profile tab
It would also be nice if we could assign this to a workflow and not just a person. A more likely scenario is that an App that needs a user input shouldn't be scheduled since it won't work.
To have the ability to turn off the scheduling for just that workflow is more likely then to turn off that feature for an entire person.
The AlteryxService addtoqueue command is great, but it leaves me wanting more. My simple use case is to run WorkflowB via the addtoqueue command in an after run event from WorkflowA, which is run daily. The result is that i end up with a cluttered scheduler with many instances of WorkflowB that i need to manually clean up, since addtoqueue creates a new record in AS_Applications each time it runs
It would be useful if there was an AlteryxService command for each of the subroutines already built in to the scheduler front end app: schedule workflow, update workflow, add workflow, remove workflow, edit schedule, etc
MongoDB objects could be identified by oid which the user can get from querying the AlteryxService database
I don't want to rebuild what you've already built, just need a little more control over it 🙂
I wish Alteryx would allow more control over user access to scheduling workflows. Currently there is only a radio button that globally allows users to access the scheduler. I wish we had another layer where we could limit access by Permissions. For example, we would like all Artisans and Curators to have access to the scheduler, but not viewers.