This discussion is archived
1 Reply Latest reply: Dec 10, 2012 1:31 PM by 460360 RSS

error when I try to enable job. ORA-27483

460360 Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points