ORA-27367: program "schemaname.programname" associated with this job is disabled
Hi,
I am trying to execute a job scheduled using dbms_scheduler. Getting the error mentioned in the subject line.
Below is job created:
BEGIN
DBMS_SCHEDULER.CREATE_PROGRAM (
program_name => 'LOAD_DATA',
program_action => 'LOAD_NEW_DATA',
program_type => 'STORED_PROCEDURE');
END;
BEGIN
DBMS_SCHEDULER.CREATE_SCHEDULE (
schedule_name => 'NEW_Data_Load_schedule',
start_date => TO_TIMESTAMP('23-Nov-15 02:00:00.000000', 'DD-Mon-RR HH24:MI:SS.FF'),
repeat_interval => 'FREQ=DAILY; INTERVAL=1; BYDAY= MON,TUE,WED,THU,FRI',
comments => 'Load NEW data every day except SAT and SUN');
END;
BEGIN
DBMS_SCHEDULER.CREATE_JOB (
job_name => 'LOAD',
program_name => 'LOAD_DATA',