How to move the Jobs from one User to another User Present in different servers now.
Vinesh, October 22, 2021 - 6:04 am UTC
Thanks for your response Chris.
The code shared by you works fine when we have only few jobs. But our production server has around 300 jobs. We are migrating our DB to 19c Version.
Any SQL code that would help us in this regards.
October 26, 2021 - 2:38 am UTC
Not sure how the number really make a big difference, ie
select dbms_metadata.get_ddl('PROCOBJ',job_name, owner) from dba_scheduler_jobs
gets the DDL for all them
Thank You Note
vinesh, October 26, 2021 - 4:59 pm UTC
Thanks a lot for your help !!.
Sorry to say that I missed the basic fundamentals over here !!
October 27, 2021 - 2:16 am UTC
No problem. We all learn everyday