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.