Retrieve information about scheduled tasks

Discussion created by Antoine_Sauteron_1266 on May 31, 2017
Latest reply on Dec 11, 2018 by FrankMuffke
We need to feed referential of existing scheduled jobs.
1 - I would like to know if it is possible to export in command line, all the task properties of scheduled objects (Start time, Variable & prompts [with values of each promptsets] , Calendar).
2 - If not possible, can you tell me where I can find this information in database (Can you provide the sql query ?)

1 - There is no command line tool that would allow you to retrieve this information.
2 - Not sure if a SQL query may be possible, therefore I'm posting this on your behalf on the Community so everyone can contribute :)

The out-of-the-box tool that seems to be closes to what you are looking for would be the Autoforecast feature.
It allows you to search for upcoming runs, based on adjustable criteria :


However it does not return calendar conditions, variables, and contents of promptsets.

Best regards,