Hj Experts,
I am unable to get DDL of Scheduler jobs ,
FYI => I just changed job_name and schema name (just dummy names is pasted following below)
SQL> select job_name, job_type,auto_drop,last_start_date, state,owner from all_scheduler_jobs
2 where job_name=JOB1';
JOB_NAME JOB_TYPE AUTO_ LAST_START_DATE STATE OWNER
---------------------------------------- ---------------- ----- ------------------------------------------ -------------------- ------------
JOB1 FALSE 24-OCT-19 07.07.43.499000 PM GMT SCHEDULED SCHEMA1
Error is here
-------------------
SQL> select dbms_metadata.get_ddl('PROCOBJ', 'JOB1','SCHEMA1') from dual;
ERROR:
ORA-31603: object "JOB1" of type PROCOBJ not found in schema SCHEMA1"
ORA-06512: at "SYS.DBMS_METADATA", line 6478
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105
ORA-06512: at "SYS.DBMS_METADATA", line 6465
ORA-06512: at "SYS.DBMS_METADATA", line 9202
ORA-06512: at line 1
no rows selected
DB : 12.2