dbms_jobs and redo activity

Will submitting jobs via dbms_jobs result, in itself, in transactions being writen to redo logs? John -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Dunn INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego

Re: dbms_jobs and redo activity

Yes, its basically an insert into SYS.JOB$ hth connor --- John Dunn [EMAIL PROTECTED] wrote: Will submitting jobs via dbms_jobs result, in itself, in transactions being writen to redo logs? John -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John

Re: dbms_jobs and redo activity

Yes. Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, March 18, 2002 5:43 AM Will submitting jobs via dbms_jobs result, in itself, in transactions being writen to redo logs? John -- Please

RE: dbms_jobs

Less keystrokes, yes, but the long version is less likely to generate questions like 'What do those numbers mean?' :) There in the books :) Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes. Christopher

Re: dbms_jobs

On Monday 10 September 2001 06:35, Christopher Spence wrote: Less keystrokes, yes, but the long version is less likely to generate questions like 'What do those numbers mean?' :) There in the books :) Geez Chris, of course they're in the books. That doesn't stop people from asking. :)

RE: dbms_jobs

Yeah, just say RTFM :) Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes. Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax:(707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford

Re: dbms_jobs

Less keystrokes, yes, but the long version is less likely to generate questions like 'What do those numbers mean?' :) Other jobs running on the database is not really a factor in the timing of my test, as there are no other jobs in the database, and I am the only user of the entire box. Jared

Re: dbms_jobs

Hi, Jared, I ran your scripts and indeed strange behaviour. First of all I now tested my earlier statement (never had to work much with jobs before) and it appears to be incorrect. Interval is evaluated before the job starts and not after completion (As it says in the manual, that I have now

RE: dbms_jobs

I find it easier, takes less keystrokes, I am the world's worst typist, to SCHEDULE A JOB TO RUN AT 9:45 pm and run every five minutes thereafter exec dbms_job.submit(:jobno,'procedure;', trunc(sysdate) + 21.75/24, 'trunc(sysdate,''MI'') + 5/1440') Also bear in mind the job_queue_interval

Re: dbms_jobs

Hi As far as I know the job will be rescheduled after the job completes. So in your examples the job will start one hour after the two hour job finishes. Jack David Turner [EMAIL PROTECTED]@fatcity.com on 06-09-2001 05:35:32 Please respond to [EMAIL PROTECTED] Sent by: [EMAIL

Re: dbms_jobs

Any thoughts on how this was scheduled this way? Schedule a job that takes 10 minutes, set the interval to run 5 minutes after the first job starts. Here's the job: create or replace procedure dummy is begin -- sleep for 10 minutes -- envy the computer -- waiting for interruption

dbms_jobs

I was wondering if you schedule a job to run every hour and say the job takes 2 hours to run. Will the next run of the job queue up or will it run in parallel with the current job? I'll be testing this but if anyone knows I would appreciate it? Also if the second job waits for the first job to

Re: dbms_jobs

-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Arich Henneman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists