1 Reply Latest reply: Dec 10, 2012 3:31 PM by user457357 RSS

    error when I try to enable job. ORA-27483

    user457357
      I have a job that when I try and enable I get the following error.

      PROD_SQL>exec sys.dbms_scheduler.enable(name=>'"BAN_SOUTST"."CHECK_WRITER"');
      BEGIN sys.dbms_scheduler.enable(name=>'"BAN_SOUTST"."CHECK_WRITER"'); END;

      *
      ERROR at line 1:
      ORA-27483: "BAN_SOUTST.CHECK_WRITER" has an invalid END_DATE
      ORA-06512: at "SYS.DBMS_ISCHED", line 4394
      ORA-06512: at "SYS.DBMS_SCHEDULER", line 2802
      ORA-06512: at line 1

      The problem is that my end date is after my start date so I do not know why I am getting this error.

      PROD_SQL>select start_date, repeat_interval, end_date from dba_scheduler_jobs where job_name = 'CHECK_WRITER';

      START_DATE
      ---------------------------------------------------------------------------
      REPEAT_INTERVAL
      --------------------------------------------------------------------------------
      END_DATE
      ---------------------------------------------------------------------------
      10-DEC-12 08.06.00.000000 AM -08:00
      FREQ=MINUTELY
      10-DEC-12 06.00.00.000000 PM -08:00

      Oracle 11gR2