Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> DBMS_JOB.SUBMIT killing/cancelling a job

DBMS_JOB.SUBMIT killing/cancelling a job

From: jobs <jobs_at_webdos.com>
Date: 18 May 2007 08:04:43 -0700
Message-ID: <1179500683.810309.52040@p77g2000hsh.googlegroups.com> 





I have connection (from SQL Server SSIS) that launches and monitor
jobs in Oracle (9i and 10g).



I can tell if a job is currently running from a



select * from all_jobs; in oracle.



The cleanest/safest way to stop or cancel a job in oracle so that it
disappears from all_jobs is and not doing anything any longer?
Received on Fri May 18 2007 - 10:04:43 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US