Using dbms_job package

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.

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


* 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.                             *

\******************************************************/