Re: DBMS_JOB question

first, open init.ora or inst.ora which ever is applicable to u and find whether the following entries are there or not

job_queue_processes=(something)

job_queue_interval=(something)

if they are not there then add them

example

job_queue_processes=2 (between 0 and 10) job_queue_interval=3 (between 1 and 3600)

then procede with following script

i've tried this and its working fine....

declare
jobnum number;
begin

/* note that the name of the procedure is inside two single quotes 'tempinsert;' also note that semicolon is placed after the procedurename folowed by a comma */

/* this procedure would be invoked at 00:15 and then subsequently the same time there after ie 00:15 each midnight*/

dbms_job.submit(jobnum,'tempinsert;',
trunc(sysdate+24.25/24,'sysdate+1');

end;
/

hope this helps u ,
keep me informed

Mick Cooke wrote in message <01becd00$7813a500$c76464c0_at_mickc.hmp-parc>...
>Oracle 7.3.3 NT 4.0 SP3
>
>I have to set up 2 dbms jobs 1) to run at 00:15 the other at 00:30. the
>database is being used for testing and so is only started for short
>periods. the details of the jobs are;
>
>declare
> jobno number;
>begin
>-- schedule this job to run at 15 minutes past midnight
> dbms_job.submit(jobno,nameofjob1);',
> trunc(sysdate)+24.25/24,'sysdate+1');
>-- schedule this job to run at 30 minutes past midnight
>dbms_job.submit(jobno,nameofjob2);',
> trunc(sysdate)+24.5/24,'sysdate+1');
>end;
>/
>
>when the jobs run the next_date,next_sec query displays that the next time
>the jobs run will be 15mins and 30 mins later on the next run i.e 00:30 and
>01:00 respectively
>Also when the database is shut down an restarted both jobs run time
>defaults to the startup time.
>
>Could anyone out there please enlighten me as to an errors in my job script
>or point me in the right direction for a solution.
>
>Thanks in advance
Received on Tue Jul 13 1999 - 04:54:09 CDT