1 Reply Latest reply on Dec 10, 2012 9:31 PM by user457357

    error when I try to enable job. ORA-27483

      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';

      10-DEC-12 AM -08:00
      10-DEC-12 PM -08:00

      Oracle 11gR2