BEGIN 
dbms_scheduler.create_job('"UPDATE_ON_DEMAND_JIRA_DE_SNAPSHOTS_JOB"',
job_type=>'PLSQL_BLOCK', job_action=>
'BEGIN
    UPDATE_ON_DEMAND_JIRA_DE_SNAPSHOTS_ASSETS_MAPPING_TB_PROC;
    UPDATE_ON_DEMAND_JIRA_DE_SNAPSHOTS_ORIGINAL_MAPPING_TB_PROC;
    UPDATE_ON_DEMAND_JIRA_DE_SNAPSHOTS_ASSETS_STRATEGIC_PRIORITY_SOLUTION_TB_PROC;
    UPDATE_ON_DEMAND_JIRA_DE_SNAPSHOTS_ISSUES_TARGETVERSION_COMPLETIONPERIOD_TB_PROC;
    UPDATE_ON_DEMAND_JIRA_DE_SNAPSHOTS_ISSUESMAPPING_VALUESTREAM_TB_PROC;
END;'
, number_of_arguments=>0,
start_date=>TO_TIMESTAMP_TZ('05-NOV-2025 10.59.20.580158000 AM EUROPE/PRAGUE','DD-MON-RRRR HH.MI.SSXFF AM TZR','NLS_DATE_LANGUAGE=english'), repeat_interval=> 
'FREQ=DAILY;BYTIME=030000;BYDAY=MON,TUE,WED,THU,FRI,SAT,SUN'
, end_date=>NULL,
job_class=>'"DEFAULT_JOB_CLASS"', enabled=>FALSE, auto_drop=>FALSE,comments=>
NULL
);
sys.dbms_scheduler.set_attribute('"UPDATE_ON_DEMAND_JIRA_DE_SNAPSHOTS_JOB"','NLS_ENV','NLS_LANGUAGE=''AMERICAN'' NLS_TERRITORY=''AMERICA'' NLS_CURRENCY=''$'' NLS_ISO_CURRENCY=''AMERICA'' NLS_NUMERIC_CHARACTERS=''.,'' NLS_CALENDAR=''GREGORIAN'' NLS_DATE_FORMAT=''DD-MON-RR'' NLS_DATE_LANGUAGE=''AMERICAN'' NLS_SORT=''BINARY'' NLS_TIME_FORMAT=''HH.MI.SSXFF AM'' NLS_TIMESTAMP_FORMAT=''DD-MON-RR HH.MI.SSXFF AM'' NLS_TIME_TZ_FORMAT=''HH.MI.SSXFF AM TZR'' NLS_TIMESTAMP_TZ_FORMAT=''DD-MON-RR HH.MI.SSXFF AM TZR'' NLS_DUAL_CURRENCY=''$'' NLS_COMP=''BINARY'' NLS_LENGTH_SEMANTICS=''BYTE'' NLS_NCHAR_CONV_EXCP=''FALSE''');
dbms_scheduler.enable('"UPDATE_ON_DEMAND_JIRA_DE_SNAPSHOTS_JOB"');
COMMIT; 
END; 
/