I am in the process of building a "Command Center" for our business unit. There are many users who schedule workflows. Part of the command center's role is to notify users when their schedules do not run or are disabled.(this is outside of error/failure checking built into a workflow).
The current process is to have each user manually check periodically to see if they workflows were disabled. I am trying to build a workflow that removes this need by automating this. The workflows are distributed across various private galleries. My initial thought was thus:
- Any time a user creates a new schedule, they let me know.
- I add it to a database/spreadsheet(master schedule)
- A "master" workflow would then check the alteryx gallery schedules and compare it to the master spreadsheet schedule.
- If something deviated in that comparison an automated email would be sent out to notify users of the deviation.
This all hinges on step 4 being possible. Is that possible?
Put more simply, is there a database I could connect to track scheduled workflows?
Thanks,
Craig
Craig