Re: Using dbms_job package

I think you need a commit after you call dbms_job.submit. This is all that I see
wrong from what you wrote.

Steve J.

Mark Pether wrote:
>
> 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. *
> \******************************************************/
Received on Fri Sep 12 1997 - 00:00:00 CDT