Re: 10g job scheduler errors

"Ana C. Dent" <anacedent_at_hotmail.com> wrote in message news:<Xns955DBC002D1D4SunnySD_at_68.6.19.6>...
> 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?

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. Received on Wed Sep 08 2004 - 23:15:31 CEST