dbms_job [message #519260] |
Wed, 10 August 2011 09:56 |
sathik
Messages: 196 Registered: August 2009 Location: INDIA
|
Senior Member |
|
|
There are 3 databases named sm01,sm02 and sm03. All are resides in different servers.
Job_queue_processes=5 in all 3 databases.
There is a schema called sas_owner in all databases. There are 2853,6801,7 jobs are in SAS_OWNER schema in these 3 databases respectively.
my proplem is, the job I have scheduled in SAS_OWNER schema resides in sm01 and sm02 are not running automatically. But if I run manually, it is running fine.
But in sm03 the jobs are running automatically. no issues in sm03.
So I am planning to increase the value of job_queue_processes in sm01 and sm02. But I dont know what value I need to put for this parameter. is there any calculation to assign a value for this parameter?
[Updated on: Wed, 10 August 2011 10:06] Report message to a moderator
|
|
|
|
Re: dbms_job [message #519264 is a reply to message #519262] |
Wed, 10 August 2011 10:15 |
sathik
Messages: 196 Registered: August 2009 Location: INDIA
|
Senior Member |
|
|
but in my local db, I tested as below.
Job_queue_processes=1
I created 14 jobs as below. Only the job id value I have given differently. These 14 jobs are executing propely even job_queue_processes=1 . in that case how we can say no of job_queue_processes=no of job at a time.
BEGIN
DBMS_JOB.isubmit (
job => 101,
what => 'insert into abc values (1);',
next_date => sysdate,
interval => 'sysdate+15/86400');
commit;
end;
/
|
|
|
Re: dbms_job [message #519267 is a reply to message #519264] |
Wed, 10 August 2011 11:04 |
|
Michel Cadot
Messages: 68693 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
dbms_job.isubmit does not exist (for you).
NEVER EVER use it.
And I don't see any reason why you use this.
Start by correctly use the package and Oracle then you will have less problems.
Regards
Michel
[Updated on: Wed, 10 August 2011 11:05] Report message to a moderator
|
|
|
|