Is there a way of exporting Scheduled Jobs in Hyperion IR out of repository using SQL or any other way and then importing it in the new environment ?
We are migrating from version 8.3 to version 220.127.116.11 and I know from the documentation that there is no migration utility provided by oracle for this. But the repository tables for scheduled jobs look pretty similar on 8.3 and 18.104.22.168?
We have hundreds of scheduled jobs and recreating them one by one again in EPM 22.214.171.124 will take ages. We have done this manual process for on demand bqy's, but it doesn't look practical for Scheduled jobs.
You could try the path from 8.3 to 126.96.36.199 , this allow you to use the migration utility to move the jobs. Then upgrade to 188.8.131.52.
So you will have all the jobs in 184.108.40.206.
For your information you cannot directly move to 220.127.116.11 from a earlier version like 8.3 . Refer the readme " http://docs.oracle.com/cd/E17236_01/epm.1112/epm_1112200_readme.pdf " for the "Supported Paths to this Release"