10g job scheduler errors
From: Dave Anderson <dave_at_skillbuilders.com>
Date: 7 Sep 2004 09:51:50 -0700
Message-ID: <a0dc4048.0409070851.72c30c39_at_posting.google.com>
Has anyone encountered this error when running a job using the 10g job scheduler?
10 /
Date: 7 Sep 2004 09:51:50 -0700
Message-ID: <a0dc4048.0409070851.72c30c39_at_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 - 18:51:50 CEST