Oracle Job Submission Package

From: <NeedaHoliday>
Date: Wed, 16 May 2001 10:46:59 -0400
Message-ID: <ve45gt0lie14ahud788b0chnl9ven6mm2t_at_4ax.com>


Has anyone ever developed an Oracle submission package that uses DBMS_JOB.SUBMIT. I have searched through the internet for an answer on how to abort executing jobs on the SNP processes. I can find the BROKEN command but it only works on queued jobs.

 Is there a PL/SQL command to abort execution of a procedure? I am looking at other alternatives ans one is to abort the job in midstream.

Any input would be greatly appreciated.

james.stewart_at_nospamPWGSC.GC.CA

omit nospam to email

Thanks Received on Wed May 16 2001 - 16:46:59 CEST

Original text of this message