DBMS_JOB fails to schedule job

From: Richard G. Ramirez <ou79138_at_deere.com>
Date: 1995/11/01
Message-ID: <DHDwE4.E1u_at_deere.com>#1/1

I am testing DBMS_JOB using Oracle 7.1. I am able to schedule the job without errors but the process never executes automatically.When I use DBMS_JOB.RUN(2);, it executes without problem and it modifies the 'last date' column in DBA_JOBS.

The two jobs below perform the same thing (insert a row to a table). One uses a stored procedure, the other an INSERT as part of the DBMS_JOB.SUBMIT.

My guess is that I don't understand intervals but I can't see my mistake.

Any ideas?

Thanks.

Richard

---

declare
  job# BINARY_INTEGER;
begin
 dbms_job.submit(job#,

      'insert into rgr.test_job values (sysdate, ''job 2'',33);', 
       sysdate, 'sysdate+1/720');

end;
/

SQL>
SQL> select job, schema_user,

  2         to_char(next_date, 'MM/DD/YY HH:MI:SS') next_date, 
  3         to_char(last_date, 'MM/DD/YY HH:MI:SS') last_date, 
  4         interval, 
  5         broken

  6 --what
  7 from sys.dba_jobs;

       JOB SCHEMA_USER NEXT_DATE LAST_DATE

---------- ------------ -------------------- --------------------
INTERVAL             B
-------------------- -
         3 RGR          11/01/95 03:35:49    11/01/95 03:33:49
sysdate+1/720        N

         2 RGR          11/01/95 03:16:30
sysdate+1/720        N

Received on Wed Nov 01 1995 - 00:00:00 CET