Alteryx server Job frequency

[kiranbsharma]

Hi Alteryx community

We need to publish the list of all job schedules every day. The information is available in mongo_DB tables. I followed the instructions given at https://community.alteryx.com/t5/Alteryx-Server-Knowledge-Base/Query-Scheduler-Database-from-Alteryx... and I was able to get job owner, create time, next run, last run information. But I was not able to get job priority, frequency, worker assigned information. Which Mongo DB table/column has this information?

Thank you

Kiran

[DanM]

@kiranbsharma 

You should be using the Server Usage App which can be found in the downloads page of the Alteryx Server. That will allow you to see more user information.

[mbarone]

@kiranbsharma 

The server usage report is great.  If you really just want a few key fields from Mongo regarding scheduler, then grab the service data parser macro from the server usage report, and drop it on a canvas with a Mongo input tool.  Connect the two, and configure it as follows (the password is the NON admin one in your server settings).  Run it and you'll see all the fields you mentioned.