Re: 10g job scheduler errors

dave_at_skillbuilders.com (Dave Anderson) wrote in news: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
>

IIRC, DBMS_SCHEDULER.CREATE_JOB is a FUNCTION as the error message indicates. If so, then why are you calling it as a procedure? Received on Wed Sep 08 2004 - 03:28:51 CEST