Job starting problem

#1

Hi,
I have a problem with jobs -after creating a job
when goes time of its execution nothing happens.
When I start job manually (dbms_job.run) it starts,
but on next execution time nothing happen again.
This is Oracle9i (Enterprise Edition Release 9.2.0.4.0) databease,
the job_queue_processes parameter is set to 1,
the job_queue_interval is not set (it is not used in this version, but even
set it not help).
Restart of database does not help, last time after restart of server it
start work,
but It can not do this to often.
Any ideas, what I can check?

Regards,
Wojtek

#2

"Wojtek Wawrzyniak" <wojciech.wawrzyniak (AT) quantum (DOT) pl> wrote in
news:cuv199$4q4$1 (AT) atlantis (DOT) news.tpi.pl:

Quote:

Hi,
I have a problem with jobs -after creating a job
when goes time of its execution nothing happens.
When I start job manually (dbms_job.run) it starts,
but on next execution time nothing happen again.
This is Oracle9i (Enterprise Edition Release 9.2.0.4.0) databease,
the job_queue_processes parameter is set to 1,
the job_queue_interval is not set (it is not used in this version, but
even set it not help).
Restart of database does not help, last time after restart of server
it start work,
but It can not do this to often.
Any ideas, what I can check?

Regards,
Wojtek

Try issuing a COMMIT after the DBMS_JOB line. ;-)

#3

Quote:

Try issuing a COMMIT after the DBMS_JOB line. ;-)

I do this (every time).. :-)
Wojtek

#4

alertlog

Wojtek Wawrzyniak wrote:

Quote:

Hi,
I have a problem with jobs -after creating a job
when goes time of its execution nothing happens.
When I start job manually (dbms_job.run) it starts,
but on next execution time nothing happen again.
This is Oracle9i (Enterprise Edition Release 9.2.0.4.0) databease,
the job_queue_processes parameter is set to 1,
the job_queue_interval is not set (it is not used in this version, but even
set it not help).
Restart of database does not help, last time after restart of server it
start work,
but It can not do this to often.
Any ideas, what I can check?

Regards,
Wojtek

--
WS1-UANIC

#5

In alertlog there is no errors.

WW

Uzytkownik "Waldhausen" <wald_no (AT) spam_wit (DOT) kiev.ua> napisal w wiadomosci
news:cv1rc2$lmc$1 (AT) news (DOT) wnet.ua...

Quote:

alertlog

Wojtek Wawrzyniak wrote:
Hi,
I have a problem with jobs -after creating a job
when goes time of its execution nothing happens.
When I start job manually (dbms_job.run) it starts,
but on next execution time nothing happen again.
This is Oracle9i (Enterprise Edition Release 9.2.0.4.0) databease,
the job_queue_processes parameter is set to 1,
the job_queue_interval is not set (it is not used in this version, but
even
set it not help).
Restart of database does not help, last time after restart of server it
start work,
but It can not do this to often.
Any ideas, what I can check?

Regards,
Wojtek

--
WS1-UANIC

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Job starting problem

comp.databases.oracle.misc comp.databases.oracle.misc

Job starting problem - 02-16-2005 , 02:45 AM

Re: Job starting problem - 02-16-2005 , 09:35 AM

Re: Job starting problem - 02-17-2005 , 03:54 AM

Re: Job starting problem - 02-17-2005 , 04:24 AM

Re: Job starting problem - 02-22-2005 , 04:35 AM