469,111 Members | 1,961 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,111 developers. It's quick & easy.

10g job scheduler errors

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
Jul 19 '05 #1
2 9668
da**@skillbuilders.com (Dave Anderson) wrote in
news:a0**************************@posting.google.c om:
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


IIRC, DBMS_SCHEDULER.CREATE_JOB is a FUNCTION as the error message
indicates. If so, then why are you calling it as a procedure?
Jul 19 '05 #2
"Ana C. Dent" <an*******@hotmail.com> wrote in message news:<Xn*********************@68.6.19.6>...
da**@skillbuilders.com (Dave Anderson) wrote in
news:a0**************************@posting.google.c om:
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


IIRC, DBMS_SCHEDULER.CREATE_JOB is a FUNCTION as the error message
indicates. If so, then why are you calling it as a procedure?


I'm not sure I follow you. My call to DBMS_SCHEDULER.CREATE_JOB works
fine (I think - all bets are off). It is documented as a procedure.
It's the call to exec dbms_scheduler.run_job('daily_backup') that
fails.
Jul 19 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by keepyourstupidspam | last post: by
8 posts views Thread by VMI | last post: by
4 posts views Thread by Sid Price | last post: by
1 post views Thread by Prof. William Battersea | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by kglaser89 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.