Stopping Oracle database jobs

If your database has scheduled jobs, you must unschedule them and clear the jobs queue before you run the Update Readiness Tool and start the migration process. After the jobs are unscheduled and the jobs queue is clear, you can run the Update Readiness Tool and continue your migration.
  1. Log on to SQL*Plus using the
    Symantec Data Loss Prevention
    database user name and password.
  2. Run the following:
    BEGIN FOR rec IN (SELECT * FROM user_jobs) LOOP dbms_job.broken( rec.job, true); dbms_job.remove( rec.job); END LOOP; END; /
  3. Verify that all jobs are unscheduled by running the following:
    select count(*) from user_jobs;
    Confirm that the count is zero. If the count is not zero, run the command to clear the queue again. If a job is running when you attempt to clear the queue, the job continues to run until it completes and is not cleared. For long running jobs, Symantec recommends that you wait for the job to complete instead of terminating the job.
  4. Exit SQL*Plus.