Getting DDL for a scheduler job

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,
start_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=> 
'FREQ=MINUTELY;INTERVAL=5'
, end_date=>NULL,
job_class=>'"DEFAULT_JOB_CLASS"', enabled=>FALSE, auto_drop=>TRUE,comments=>
NULL
);
dbms_scheduler.set_attribute('"CHECK_TEMP_FREE"','logging_level',DBMS_SCHEDULER.LOGGING_RUNS);
dbms_scheduler.enable('"CHECK_TEMP_FREE"');
COMMIT; 
END; 

-----------------------------------------------
13:29:04 oracle@oh1xpwcdb01 ~ >

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.