is there a way to collect this info from alteryx scheduler without manually typing it?
Solved! Go to Solution.
@SAPaul You should be able to source this information from the persistence layer of your Alteryx Server environment.
AlteryxService MongoDB Schema | Alteryx Help
The AS_Schedules should have what you are looking for.
@gautiergodard I only have alteryx designer on a PC, not on a server.
@SAPaul you should still be able to retrieve information in regards to your Desktop scheduler by going to the location of your scheduler DB, in my case its here: C:\ProgramData\Alteryx\Service\Persistence
I believe this is the location @gautiergodard is referring to when he mentioned the AS_Schedules. You should be able to pull the sqlite files from the AS_Schedules folder into Alteryx designer to retrieve information regarding your scheduled workflows.
Hope that helps!
thanks, it seems to be missing frequency which is a shame.
Do you have any ideas why my 'module name' column is null?
I don't know why the module name would be null, this column would contain the workflow file name. The AS_Schedules schema would contain a column called LC_ScheduleName, which is the workflow name.
Maybe one way to find out is to pull in the files from AS_Application and AS_Schedules into Alteryx and join them on their _id to see if there's a match and corresponding workflow name?