Database Administration (MOSC)

MOSC Banner

ORA-27367: program "schemaname.programname" associated with this job is disabled

edited Dec 11, 2015 10:10AM in Database Administration (MOSC) 1 commentAnswered

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center