Extraction of job data for oracle will now correctly create sql statement when object name requires single quote escaping.  Scripting of job properties that are wrapped in a single quote will now correctly escape any single quotes in the string.  Open/Close quote identifiers will now correctly be used when scripting.  Below is an example that should extract and script correctly in oracle 12c:

 

BEGIN

sys.dbms_scheduler.DROP_JOB ('"C##DB_LEFT"."IVAN''S TEST JOB"');

END;

GO

BEGIN

sys.dbms_scheduler.create_job

(

job_name => '"C##DB_LEFT"."IVAN''S TEST JOB"',

job_type => 'PLSQL_BLOCK',

job_action => 'BEGIN DBMS_STATS.GATHER_TABLE_STATS(''C##DB_LEFT'',''CUSTOMER''); END;',

repeat_interval => 'FREQ=DAILY',

job_class => 'DEFAULT_JOB_CLASS',

auto_drop => TRUE,

enabled => TRUE

);

sys.dbms_scheduler.set_attribute(name=> '"C##DB_LEFT"."IVAN''S TEST JOB"', attribute => 'job_priority', value =>'3');

sys.dbms_scheduler.set_attribute(name=> '"C##DB_LEFT"."IVAN''S TEST JOB"', attribute => 'max_runs', value =>'3');

sys.dbms_scheduler.set_attribute(name=> '"C##DB_LEFT"."IVAN''S TEST JOB"', attribute => 'max_failures', value =>'3');

sys.dbms_scheduler.set_attribute(name=> '"C##DB_LEFT"."IVAN''S TEST JOB"', attribute => 'logging_level', value =>DBMS_SCHEDULER.LOGGING_OFF);

sys.dbms_scheduler.set_attribute(name=> '"C##DB_LEFT"."IVAN''S TEST JOB"', attribute => 'job_weight', value =>'12');

sys.dbms_scheduler.set_attribute(name=> '"C##DB_LEFT"."IVAN''S TEST JOB"', attribute => 'instance_stickiness', value =>TRUE);

sys.dbms_scheduler.set_attribute(name=> '"C##DB_LEFT"."IVAN''S TEST JOB"', attribute => 'restartable', value =>FALSE);

sys.dbms_scheduler.set_attribute(name=> '"C##DB_LEFT"."IVAN''S TEST JOB"', attribute => 'stop_on_window_close', value =>FALSE);

END;

GO