Oracle Job Submission Package
From: <NeedaHoliday>
Date: Wed, 16 May 2001 10:46:59 -0400
Message-ID: <ve45gt0lie14ahud788b0chnl9ven6mm2t_at_4ax.com>
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