Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Using dbms_job package

Using dbms_job package

From: Mark Pether <markap_at_bom.gov.au>
Date: 1997/09/12
Message-ID: <3418B394.5E35@bom.gov.au>#1/1

Hello all,

I'm hoping to execute a program every night that will create a series of datafiles, the problem is...

Good 'ol dbms_job package it refuses to execute any jobs in the future.

The manual execution works ok ie. dbms_job.run(job#), but when I set a time in future say:

set serveroutput on size 100000
declare
  job integer;
begin
  dbms_job.submit(job,'fred;',sysdate+10/60/24,'sysdate+10/60/24'); -- every 10 minutes
  dbms_output.put_line('job in queue: '||job); end;
/

^^ Absolutely nothing happens, I know this because I check the next_date in user_jobs and it stays the same!

I have setup the following parameters in init.ora file:

job_queue_processes=2
job_queue_interval=60
job_queue_keep_connections=false

Restarted Oracle Ok, and checked that the SNPx Oracle processes are ok!

Am I missing something, or should I just cron the job with an sqlplus session every night?

Any help appreciated!

-- 
/******************************************************\

* Mark Pether email: markap_at_bom.gov.au *
* Bureau of Meteorology phone: 03 9669 4709 *
* National Climate Centre fax: 03 9669 4515 *
* GPO Box 1289K Melbourne, *
* Victoria 3001 Australia. *
\******************************************************/
Received on Fri Sep 12 1997 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US