Abort the Long-Running Jobs

1. Log in to SQL*Plus as apps.
2. Run the following query to find the long running jobs:

   select * from cdr_jobs where job_status_rc like '%EXECUTING%';

3. Log in to the Oracle LSH application.
4. Navigate to Life Sciences Data Hub > Job Execution.
5. Search for the job using the job ID and cancel it.