If you need to copy the DDL to create a scheduler job from one schema to another, what is below works well…<\/p>\n
\r\n13:28:56 oracle@oh1xpwcdb01 ~ >.\/dynColumns.py \"select dbms_metadata.get_ddl('PROCOBJ','CHECK_TEMP_FREE','HOWARDS') from dual\"\r\n-----------------------------------------------\r\n \r\nBEGIN \r\ndbms_scheduler.create_job('\"CHECK_TEMP_FREE\"',\r\njob_type=>'PLSQL_BLOCK', job_action=>\r\n'begin oclc_checks.check_temp_free(10); end;'\r\n, number_of_arguments=>0,\r\nstart_date=>TO_TIMESTAMP_TZ('03-OCT-2009 04.40.00.000000000 PM AMERICA\/NEW_YORK','DD-MON-RRRR HH.MI.SSXFF AM TZR','NLS_DATE_LANGUAGE=english'), repeat_interval=> \r\n'FREQ=MINUTELY;INTERVAL=5'\r\n, end_date=>NULL,\r\njob_class=>'\"DEFAULT_JOB_CLASS\"', enabled=>FALSE, auto_drop=>TRUE,comments=>\r\nNULL\r\n);\r\ndbms_scheduler.set_attribute('\"CHECK_TEMP_FREE\"','logging_level',DBMS_SCHEDULER.LOGGING_RUNS);\r\ndbms_scheduler.enable('\"CHECK_TEMP_FREE\"');\r\nCOMMIT; \r\nEND; \r\n\r\n-----------------------------------------------\r\n13:29:04 oracle@oh1xpwcdb01 ~ >\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"If you need to copy the DDL to create a scheduler job from one schema to another, what is below works well… 13:28:56 oracle@oh1xpwcdb01 ~ >.\/dynColumns.py “select dbms_metadata.get_ddl(‘PROCOBJ’,’CHECK_TEMP_FREE’,’HOWARDS’) from dual” ———————————————– BEGIN dbms_scheduler.create_job(‘”CHECK_TEMP_FREE”‘, job_type=>’PLSQL_BLOCK’, job_action=> ‘begin oclc_checks.check_temp_free(10); end;’ , number_of_arguments=>0,…<\/p>\n