10g job scheduler errors

From: Dave Anderson <dave_at_skillbuilders.com>
Date: 7 Sep 2004 09:51:50 -0700
Message-ID: <a0dc4048.0409070851.72c30c39@posting.google.com>

Has anyone encountered this error when running a job using the 10g job scheduler?

SQL> exec dbms_scheduler.run_job('daily_backup') BEGIN dbms_scheduler.run_job('daily_backup'); END;

*
ERROR at line 1:
ORA-27369: job of type EXECUTABLE failed with exit code: Incorrect function.

ORA-06512: at "SYS.DBMS_ISCHED", line 148
ORA-06512: at "SYS.DBMS_SCHEDULER", line 374
ORA-06512: at line 1

This is a Windows 2000 server. The job was successfully created:

SQL> BEGIN
  2 DBMS_SCHEDULER.CREATE_JOB (

  3     job_name           =>  'daily_backup',
  4     schedule_name      =>  'dave.backup_schedule',
  5     job_type           =>  'executable',
  6     job_action         =>  'C:\OracleScripts\10g\full_backup.bat',
  7     enabled            =>  true,
  8     comments           =>  'Daily full backup');

  9 END;
 10 /

PL/SQL procedure successfully completed.

I have configured external job support by starting the OracleJobScheduler[sid] and tested the bat file from OS prompt and from within SQL*Plus using HOST.

thanks
dave Received on Tue Sep 07 2004 - 11:51:50 CDT