--new schedule--
BEGIN
  SYS.DBMS_SCHEDULER.DROP_SCHEDULE
    (schedule_name  => 'JWONG.DAILY_SCHEMA_EXPORT_SCHEDULE');
END;
/

BEGIN
  SYS.DBMS_SCHEDULER.CREATE_SCHEDULE
    (
      schedule_name    => 'JWONG.DAILY_SCHEMA_EXPORT_SCHEDULE'
     ,start_date       => TO_TIMESTAMP_TZ('2017/09/14 21:44:54.000000 America/Chicago','yyyy/mm/dd hh24:mi:ss.ff tzr')
     ,repeat_interval  => 'FREQ=DAILY;BYDAY=MON,TUE,WED,THU,FRI,SAT,SUN'
     ,end_date         => NULL
     ,comments         => 'DAILY_SCHEMA_EXPORT_SCHEDULE'
    );
END;
/

---- new job SQLDeveloper -- JWONG.DAILY_SCHEMA_EXPORT_JOB ---- PLSQL_BLOCK ---- create job under jwong account: "DAILY_SCHEMA_EXPORT_JOB" will be in jwong schema 
BEGIN
DECLARE
h1 number;
errorvarchar varchar2(100):= 'ERROR';
tryGetStatus number := 0;
begin
h1 := dbms_datapump.open (operation => 'EXPORT', job_mode => 'SCHEMA', version => 'COMPATIBLE');
tryGetStatus := 1;
dbms_datapump.set_parallel(handle => h1, degree => 1);
dbms_datapump.add_file(handle => h1, filename => 'EXPDAT_SCHEMAS-'||to_char(sysdate,'yyyy-mm-dd-hh24_mi_ss')||'.LOG', directory => 'DATAPUMP_EXPORT_DIR', filetype => 3);
dbms_datapump.set_parameter(handle => h1, name => 'KEEP_MASTER', value => 0);
dbms_datapump.set_parameter(handle => h1, name => 'COMPRESSION', value => 'ALL');
dbms_datapump.metadata_filter(handle => h1, name => 'SCHEMA_EXPR', value => 'IN(''EPM_BIPLUS'',''EPM_CALCMGR'',''EPM_EAS'',''EPM_EPMA'',''EPM_FCM'',''EPM_FDMEE'',''EPM_FM'',''EPM_MDS'',''EPM_ORABAM'',''EPM_ORASDPM'',''EPM_PLAN_APP1'',''EPM_PLAN_APP2'',''EPM_PLAN_APP3'',''EPM_PLAN_SYS'',''EPM_SOAINFRA'',''EPM_SS'')');
dbms_datapump.add_file(handle => h1, filename => 'EXPDAT%U-'||to_char(sysdate,'yyyy-mm-dd-hh24_mi_ss')||'.DMP', directory => 'DATAPUMP_EXPORT_DIR', filesize => '2000M',  filetype => 1);
dbms_datapump.set_parameter(handle => h1, name => 'INCLUDE_METADATA', value => 1);
dbms_datapump.set_parameter(handle => h1, name => 'DATA_ACCESS_METHOD', value => 'AUTOMATIC');
dbms_datapump.set_parameter(handle => h1, name => 'ESTIMATE', value => 'BLOCKS');
dbms_datapump.start_job(handle => h1, skip_current => 0, abort_step => 0);
dbms_datapump.detach(handle => h1);
errorvarchar := 'NO_ERROR';
end;
END;

----enable it if not enabled
SYS.DBMS_SCHEDULER.ENABLE(name => 'JWONG.DAILY_SCHEMA_EXPORT_JOB');
	
	
--JWONG non-sysdba ad-hoc run job--
BEGIN
  SYS.DBMS_SCHEDULER.RUN_JOB(
    JOB_NAME            => 'JWONG.DAILY_SCHEMA_EXPORT_JOB',
    USE_CURRENT_SESSION => FALSE);
END;
/

----job from TOAD----
BEGIN
  SYS.DBMS_SCHEDULER.DROP_JOB
    (job_name  => 'JWONG.DAILY_SCHEMA_EXPORT_JOB');
END;
/

BEGIN
  SYS.DBMS_SCHEDULER.CREATE_JOB
    (
       job_name        => 'JWONG.DAILY_SCHEMA_EXPORT_JOB'
      ,schedule_name   => 'JWONG.DAILY_SCHEMA_EXPORT_SCHEDULE'
      ,job_class       => 'DEFAULT_JOB_CLASS'
      ,job_type        => 'PLSQL_BLOCK'
      ,job_action      => 'BEGIN
DECLARE
h1 number;
errorvarchar varchar2(100):= ''ERROR'';
tryGetStatus number := 0;
begin
h1 := dbms_datapump.open (operation => ''EXPORT'', job_mode => ''SCHEMA'', version => ''COMPATIBLE'');
tryGetStatus := 1;
dbms_datapump.set_parallel(handle => h1, degree => 1);
dbms_datapump.add_file(handle => h1, filename => ''EXPDAT_SCHEMAS-''||to_char(sysdate,''yyyy-mm-dd-hh24_mi_ss'')||''.LOG'', directory => ''DATA_PUMP_DIR'', filetype => 3);
dbms_datapump.set_parameter(handle => h1, name => ''KEEP_MASTER'', value => 0);
dbms_datapump.metadata_filter(handle => h1, name => ''SCHEMA_EXPR'', value => ''IN(''''C##JWONG'''',''''C##PDB1ADM'''')'');
dbms_datapump.add_file(handle => h1, filename => ''EXPDAT%U-''||to_char(sysdate,''yyyy-mm-dd-hh24_mi_ss'')||''.DMP'', directory => ''DATA_PUMP_DIR'', filesize => ''1000M'',  filetype => 1);
dbms_datapump.set_parameter(handle => h1, name => ''INCLUDE_METADATA'', value => 1);
dbms_datapump.set_parameter(handle => h1, name => ''DATA_ACCESS_METHOD'', value => ''AUTOMATIC'');
dbms_datapump.set_parameter(handle => h1, name => ''ESTIMATE'', value => ''BLOCKS'');
dbms_datapump.start_job(handle => h1, skip_current => 0, abort_step => 0);
dbms_datapump.detach(handle => h1);
errorvarchar := ''NO_ERROR'';
end;
END;'
      ,comments        => 'DAILY_SCHEMA_EXPORT_JOB'
    );
  SYS.DBMS_SCHEDULER.SET_ATTRIBUTE
    ( name      => 'JWONG.DAILY_SCHEMA_EXPORT_JOB'
     ,attribute => 'RESTARTABLE'
     ,value     => FALSE);
  SYS.DBMS_SCHEDULER.SET_ATTRIBUTE
    ( name      => 'JWONG.DAILY_SCHEMA_EXPORT_JOB'
     ,attribute => 'LOGGING_LEVEL'
     ,value     => SYS.DBMS_SCHEDULER.LOGGING_OFF);
  SYS.DBMS_SCHEDULER.SET_ATTRIBUTE_NULL
    ( name      => 'JWONG.DAILY_SCHEMA_EXPORT_JOB'
     ,attribute => 'MAX_FAILURES');
  SYS.DBMS_SCHEDULER.SET_ATTRIBUTE_NULL
    ( name      => 'JWONG.DAILY_SCHEMA_EXPORT_JOB'
     ,attribute => 'MAX_RUNS');
  SYS.DBMS_SCHEDULER.SET_ATTRIBUTE
    ( name      => 'JWONG.DAILY_SCHEMA_EXPORT_JOB'
     ,attribute => 'STOP_ON_WINDOW_CLOSE'
     ,value     => FALSE);
  SYS.DBMS_SCHEDULER.SET_ATTRIBUTE
    ( name      => 'JWONG.DAILY_SCHEMA_EXPORT_JOB'
     ,attribute => 'JOB_PRIORITY'
     ,value     => 3);
  SYS.DBMS_SCHEDULER.SET_ATTRIBUTE_NULL
    ( name      => 'JWONG.DAILY_SCHEMA_EXPORT_JOB'
     ,attribute => 'SCHEDULE_LIMIT');
  SYS.DBMS_SCHEDULER.SET_ATTRIBUTE
    ( name      => 'JWONG.DAILY_SCHEMA_EXPORT_JOB'
     ,attribute => 'AUTO_DROP'
     ,value     => FALSE);
  SYS.DBMS_SCHEDULER.SET_ATTRIBUTE
    ( name      => 'JWONG.DAILY_SCHEMA_EXPORT_JOB'
     ,attribute => 'RESTART_ON_RECOVERY'
     ,value     => FALSE);
  SYS.DBMS_SCHEDULER.SET_ATTRIBUTE
    ( name      => 'JWONG.DAILY_SCHEMA_EXPORT_JOB'
     ,attribute => 'RESTART_ON_FAILURE'
     ,value     => FALSE);
  SYS.DBMS_SCHEDULER.SET_ATTRIBUTE
    ( name      => 'JWONG.DAILY_SCHEMA_EXPORT_JOB'
     ,attribute => 'STORE_OUTPUT'
     ,value     => TRUE);

  SYS.DBMS_SCHEDULER.ENABLE
    (name                  => 'JWONG.DAILY_SCHEMA_EXPORT_JOB');
END;
/
