Re: DBMS_JOB Help

Rangachari Sundar wrote: > > Hi All, > > Can Anyone tell me how to stop a background job initiated through a > DBMS_JOB package when it is no longer required? > > Thanks in advance. > > Regards > Sundar > > -- desc dbms_job I believe that this will have some effect: exec dbms_job.isbroken(

RE: DBMS_JOB Help

Hola, You can use dbms_job.remove(jobnumber) Suerte !! Ramon E. Estevez [EMAIL PROTECTED] 809-565-3121 -Mensaje original- De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]En nombre de Rangachari Sundar Enviado el: Tuesday, 28 August, 2001 1:21 AM Para: Multi

RE: DBMS_JOB Help

Use the DBA_JOBS view Ramon E. Estevez [EMAIL PROTECTED] 809-565-3121 -Mensaje original- De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]En nombre de Rangachari Sundar Enviado el: Tuesday, 28 August, 2001 9:36 AM Para: Multiple recipients of list ORACLE-L Asu

RE: DBMS_JOB Help

and DBA_JOBS_RUNNING --- Ramon Estevez <[EMAIL PROTECTED]> wrote: > Use the DBA_JOBS view > > Ramon E. Estevez > [EMAIL PROTECTED] > > 809-565-3121 > > > -Mensaje original- > De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]En > nombre de Rangachari > Sundar

RE: DBMS_JOB Help

Hi, You need to find the job number, then use DBMS_JOB.REMOVE(). This is all in the documentation: http://technet.oracle.com/doc/oracle8i_816/server.816/a76956/jobq.htm#10 57 Note that the job will complete before being removed from the queue. g -Original Message- Sent: Tuesday, Augu