--
-- dropAllDBjobs.sql
--

-- Simple script to query a list of all job ids and and then feed them to the 
-- dbms_job.remove() Procedure

DECLARE
   CURSOR jobIDcursor IS           
      SELECT   job
      FROM     user_jobs
      ORDER BY job;
BEGIN
   FOR aRecord IN jobIDcursor LOOP
     dbms_job.remove( aRecord.job );
   END LOOP;
END;
/