View Scheduler details

Question

Hi everyone, I am working on creating scheduler report details. I got some information from AS_Scehdule Table. I want more information like attached image but I am no idea how can I get this in program data or any places to display as a report table for output.

Thank you!

KGT · Answer

OK, so you just want a couple of metrics from the SQLite Db then. By default the DB should be at C:\ProgramData\Alteryx\Service\Persistence but you can check that in your system settings. The schema is not well defined publicly I don't think, as it's not a core product, more something that was offered as an in-between. But it's pretty simple.

You have AS_Schedules, you will need to combine it with Jobs (runs of the scheduled job) and possibly some others. Have a look through the tables in that directory and explore them. But the important thing you're looking for is Jobs... as that's each individual run.

gyuen7824 · Answer

Thank you for reply. I have viewed the logs. It is too much information. As I just want a part of it just like the image I provided in the topic. are there any other ways to capture it?

KGT · Answer

The logs for workflow runs are configured in Settings. In User Settings, you can configure where the logs are output to, and in System Settings there is a "more global" setting for logs. That location should house a .log file for each workflow run.