Monitor the Secure File Migration

1. Make sure at least two DBMS SCHEDULER JOBS are scheduled and running. These jobs name starts with MIGRATE_BASICFILE_TO_SECUREFILE. Execute the following command to confirm:

   Note:

   Monitor the running DBMS SCHEDULER JOBS on a daily basis until you perform Post Secure File Migration Task.

   select
   owner,
   job_name,
   JOB_ACTION,
   START_DATE,
   ENABLED,
   STATE
   from dba_SCHEDULER_JOBS
   where job_name like 'MIGRATE_BASICFILE_TO_SECUREFILE%'

2. Wait for the BASIC FILE to SECUREFILE migration to complete. You can monitor the migration progress by executing the following command:.

   select thread_id,
   Number_of_batch_to_processe,
   no_of_processed_batch,
   case when THREAD_ID in (1,2) then 'DBMS JOB SHOULD BE RUNNING'
   when Number_of_batch_to_processe > no_of_processed_batch then 'DBMS JOB SHOULD BE RUNNING'
   else 'DBMS JOB SHOULD NOT BE RUNNING' end as status
   from
   (
   select thread_id,
   count(distinct batchid) Number_of_batch_to_processe,
   (select count(1) from cdr_job_log_sfm_tmp where THREAD_ID=a.THREAD_ID and status in ('COMPLETE','FAILED')) no_of_processed_batch
   from cdr_job_log_sfm_tmp a
   group by thread_id
   );