Re: Scheduling a Pl/Sql program

Jonathan:

>Could the job be "broken"? What do you get if you issue the
>following select:

>select job,broken,failures,next_date from sys.dba_jobs;

      JOB B FAILURES NEXT_DAT
--------- - --------- --------

        4 N 25/09/98

>Until recently, I used dbms_jobs on Oracle 7.3.2 for Netware
>with no problems.

>I'm curious, why did you add 5/24 to the time when computing
>the interval?

The date/time datatype represents the hour like a decimal part of the day, this means that 24/24 is one day, 5/24 is 5 AM, 16/24 is 4 PM and so on.

Jose Lima
lima_at_ensa.org
ENSA, Vigo, Spain Received on Mon Sep 28 1998 - 02:28:56 CDT