Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Replication jobs running forever
On Wed, 07 Oct 1998 14:11:48 +0200, "Maija-Leena Kangasmäki"
<maija-leena.kangasmaki_at_tieto.com> wrote:
>My replication jobs have been running for almost 6 hours
>(dba_jobs_running) now. Is there a way to stop them ? Why do they last
>so long ?
I don't think you can stop a running job other then kill the SNP session that is runing it. The killed SNP process will auto-start itself after the job_queue_interval number of seconds (or earlier).
>Maija-Leena
HTH,
--
Jurij Modic <jmodic_at_src.si>
Certified Oracle7 DBA (OCP)
![]() |
![]() |