DB versions: 12.1, 19c
OS : RHEL
I have a 12.1 database which I was planning to migrate after 2 months. But, due to a hardware issue in the current prod server, I have to migrate this DB to a 19c pluggable database in the coming days.
In my current prod 12.1 database, I have around 10 jobs scheduled via DBMS_JOB. Yes. I know. DBMS_JOB is the old way of scheduling jobs.
But, my current priority is to quickly shift everything in the current prod to the new 19c DB. Once everything is stable in the 19c DB, I am planning to move all these jobs to DBMS_SCHEDULER.
So, I want to know if there is a way I can generate DDLs of all jobs scheduled via DBMS_JOB ? So, that I can just run these DDLs to recreate these DBMS_JOB jobs in 19c database.