Re: oracle job question

2003-04-04 Thread AK
thanks  for the reply .   -ak - Original Message - From: CP To: Multiple recipients of list ORACLE-L Sent: Thursday, April 03, 2003 5:28 PM Subject: Re: oracle job question Yes, the value for JOB_QUEUE_PROCESSES should be >0 for any scheduled jobs

Re: oracle job question

2003-04-03 Thread Wolfgang Breitling
Yep, that's the reason. At 03:53 PM 4/3/2003 -0800, you wrote: I am trying to set a job in db , but db is not executing the job although it passed the next_date (dba_jobs). when I looked at parameters i found JOB_QUEUE_PROCESSES =0 ( i guess its default). sholdn't oracle automatically kicks a

Re: oracle job question

2003-04-03 Thread Darrell Landrum
Yes, job_queue_processes must be greater than 0 (we use 2). >>> [EMAIL PROTECTED] 04/03/03 05:53PM >>> I am trying to set a job in db , but db is not executing the job although it passed the next_date (dba_jobs). when I looked at parameters i found JOB_QUEUE_PROCESSES =0 ( i guess its default).

Re: oracle job question

2003-04-03 Thread CP
Yes, the value for JOB_QUEUE_PROCESSES should be >0 for any scheduled jobs to execute. HTH CP [EMAIL PROTECTED] wrote: I am trying to set a job in db , but db is not executing the job although it passed the next_date (dba_jobs). when I looked at  parameters i found J

Re: Oracle Job Task Analysis

2003-04-02 Thread Jared . Still
Scott, This is quite a list you have compiled. I wouldn't subtract anything. The only thing I could think of to add was in the Scalability section. This section seems to concentrate on using Oracle technologies to enhance scalability, but there is another level that I think needs to be conside

RE: Oracle Job Task Analysis

2003-04-02 Thread Scott
John, That is a good question. What is the purpose of this task Analysis? I am trying to see what most DBA's perceive as what is the most important things to learn so you can manage an Oracle Database. An example would be Learning Oracle Architecture. If you are a small, medium or large company,

RE: Oracle Job Task Analysis

2003-04-02 Thread Hallas, John, Tech Dev
Scott, Is this job task analysis menat to be specific to what you do/ will do at your current site or to cover general activities thta a DBA may come across. If it is the first option it appears that you are covering almost every Oracle feature available so you must be very busy. If it is the se

Re: oracle job

2003-03-28 Thread Igor Neyman
: Multiple recipients of list ORACLE-L Sent: Friday, March 28, 2003 11:43 AM Subject: RE: oracle job if you compile package spec, then all dependent objects will be invalid, if you compile package body, then there will be no invalids.

RE: oracle job

2003-03-28 Thread Jamadagni, Rajendra
. QOTD: Any clod can have facts, having an opinion is an art !! -Original Message-From: AK [mailto:[EMAIL PROTECTED]Sent: Friday, March 28, 2003 11:04 AMTo: Multiple recipients of list ORACLE-LSubject: Re: oracle job 8.1.6   -ak - Original Message - From

Re: oracle job

2003-03-28 Thread AK
8.1.6   -ak - Original Message - From: Jamadagni, Rajendra To: Multiple recipients of list ORACLE-L Sent: Thursday, March 27, 2003 3:28 PM Subject: RE: oracle job Which version "rubs" the job? -Original Message-From: AK [mai

RE: oracle job

2003-03-27 Thread Jamadagni, Rajendra
Which version "rubs" the job? -Original Message-From: AK [mailto:[EMAIL PROTECTED]Sent: Thursday, March 27, 2003 2:29 PMTo: Multiple recipients of list ORACLE-LSubject: oracle job If the package which is going to be rub by oracle job gets compiled , does it invalids the

RE: oracle job question

2002-05-20 Thread Igor Neyman
Yes, if it's different jobs. If the same job was scheduled to run at 2:15 , 2:30 , 3:00, then oracle will run only one job. Igor Neyman -Original Message- Sent: Monday, May 20, 2002 3:48 PM To: Multiple recipients of list ORACLE-L What if I have jobs scheduled at 2:15 , 2:30 , 3:00 .

Re: oracle job question

2002-05-20 Thread BigP
What if I have jobs scheduled at 2:15 , 2:30 , 3:00 . Will oracle run them all at once if database is up at 4:00 . -Ajay - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, May 16, 2002 1:17 PM > > BigP wrote: > > > > Hi List , > > I have

Re: oracle job question

2002-05-16 Thread Stephane Faroult
> BigP wrote: > > Hi List , > I have a question regarding oracle database job . I have a database > job which runs everyday at 3pm . Due to some reason database was > shutdown between 2-4 pm . What will happen to that job . Will oracle > run this job after restaring database ? > > Thanks in adva

Re: Oracle job ???

2001-09-10 Thread Ron Rogers
Janet, Check the OTN - Skills Market place, Headhunter.net, DBAJobs.com, the Denver newspapers on line. I have seen some adds for the Denver area a few times. Good Luck, Ron ROR mª¿ªm >>> [EMAIL PROTECTED] 09/08/01 01:05AM >>> Hi all, I'm trying to find an Oracle DBA position in Denver. Does