DBMS_JOB question

From: Mick Cooke <bridgend-it_at_pavilion.co.uk>
Date: 13 Jul 1999 07:13:09 GMT
Message-ID: <01becd00$7813a500$c76464c0@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 - 02:13:09 CDT