Re: How to remove all scheduled jobs without knowing the job nos

From: Ethan Post <epost1NOepSPAM_at_yahoo.com.invalid>
Date: 2000/08/04
Message-ID: <03e8bb10.c3196575@usw-ex0105-037.remarq.com>#1/1

Here is a script, you will need to change user_jobs to all_jobs:
-Ethan http://www.freetechnicaltraining.com

---

set pause off

set linesize 60

set heading off

set term off

set feedback off

set pagesize 0

spool zjob.tmp

select 'execute dbms_job.remove('|| job ||');' from user_jobs; spool off
@zjob.tmp

---

---

Got questions? Get answers over the phone at Keen.com. Up to 100 minutes free!
http://www.keen.com Received on Fri Aug 04 2000 - 00:00:00 CDT