Schedule Jobs

Schedule the various jobs.

1. Log in as PDB sys user and schedule the jobs as mentioned below.
2. Schedule the Study Health Monitor job.

   BEGIN
     DBMS_SCHEDULER.CREATE_JOB (
      job_name           =>  'STUDY_HEALTH_REFRESH',
      job_type           =>  'STORED_PROCEDURE',
      job_action         =>  'APPS.DME_STUDY_HEALTH_GEN.REFRESH_ALL_STUDY_LC',
      repeat_interval    =>  'FREQ=MINUTELY;INTERVAL=15',
      auto_drop          =>   FALSE,
      job_class          =>  'DEFAULT_JOB_CLASS',
      comments           =>  'DMW study health StudyHealth data refresh job');
   END;
   /
   exec dbms_scheduler.enable('APPS.STUDY_HEALTH_REFRESH');

3. Schedule the Discrepancy Dashboard job.

   BEGIN
     DBMS_SCHEDULER.CREATE_JOB (
      job_name           =>  'DASHBOARD_REFRESH',
      job_type           =>  'STORED_PROCEDURE',
      job_action         =>  'APPS.DME_DASHBOARD_DISC.REFRESH_ALL_STUDY_LC',
      repeat_interval    =>  'FREQ=MINUTELY;INTERVAL=15',
      auto_drop          =>   FALSE,
      job_class          =>  'DEFAULT_JOB_CLASS',
      comments           =>  'DMW Dashboard data refresh job');
   END;
   /
   exec dbms_scheduler.enable('APPS.DASHBOARD_REFRESH');

4. Schedule the Data Cleanup job.

   BEGIN
     DBMS_SCHEDULER.CREATE_JOB (
      job_name           =>  'DATA_CLEANUP',
      job_type           =>  'STORED_PROCEDURE',
      job_action         =>  'APPS.dme_data_cleanup.CleanData',
      repeat_interval    =>  'FREQ=DAILY;INTERVAL=1',
      auto_drop          =>   FALSE,
      job_class          =>  'DEFAULT_JOB_CLASS',
      comments           =>  'DMW Data Cleanup job');
   END;
   /
   exec dbms_scheduler.enable('APPS.DATA_CLEANUP');

5. Schedule the Study Data Load Dashboard job.

   BEGIN
     DBMS_SCHEDULER.CREATE_JOB (
      job_name           =>  'SYNC_LOAD_SCHED_CONFIG',
      job_type           =>  'STORED_PROCEDURE',
      job_action         =>  'APPS.DME_DF_LOAD_SCHED_CONFIG.syncLoadSchedConfig',
      repeat_interval    =>  'FREQ=DAILY;INTERVAL=1',
      auto_drop          =>   FALSE,
      job_class          =>  'DEFAULT_JOB_CLASS',
      comments           =>  'DMW study health StudyHealth data refresh job');
   END;
   /
   exec dbms_scheduler.enable('APPS.SYNC_LOAD_SCHED_CONFIG');