10g job scheduler errors

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Dave Anderson
    #1

    10g job scheduler errors

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

    SQLexec 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_ISCHE D", line 148
    ORA-06512: at "SYS.DBMS_SCHED ULER", line 374
    ORA-06512: at line 1

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

    SQLBEGIN
    2 DBMS_SCHEDULER. CREATE_JOB (
    3 job_name = 'daily_backup',
    4 schedule_name = 'dave.backup_sc hedule',
    5 job_type = 'executable',
    6 job_action = 'C:\OracleScrip ts\10g\full_bac kup.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
    OracleJobSchedu ler[sid] and tested the bat file from OS prompt and
    from within SQL*Plus using HOST.

    thanks
    dave
    Tags: ora-06512 job
    • Ana C. Dent
      #2
      Re: 10g job scheduler errors

      dave@skillbuild ers.com (Dave Anderson) wrote in
      news:a0dc4048.0 409070851.72c30 c39@posting.goo gle.com:
      Has anyone encountered this error when running a job using the 10g job
      scheduler?
      >
      SQLexec 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_ISCHE D", line 148
      ORA-06512: at "SYS.DBMS_SCHED ULER", line 374
      ORA-06512: at line 1
      >
      This is a Windows 2000 server. The job was successfully created:
      >
      SQLBEGIN
      2 DBMS_SCHEDULER. CREATE_JOB (
      3 job_name = 'daily_backup',
      4 schedule_name = 'dave.backup_sc hedule',
      5 job_type = 'executable',
      6 job_action = 'C:\OracleScrip ts\10g\full_bac kup.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
      OracleJobSchedu ler[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?

        Comment

        • Dave Anderson
          #3
          Re: 10g job scheduler errors

          "Ana C. Dent" <anacedent@hotm ail.comwrote in message news:<Xns955DBC 002D1D4SunnySD@ 68.6.19.6>...
          dave@skillbuild ers.com (Dave Anderson) wrote in
          news:a0dc4048.0 409070851.72c30 c39@posting.goo gle.com:
          >
          Has anyone encountered this error when running a job using the 10g job
          scheduler?

          SQLexec 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_ISCHE D", line 148
          ORA-06512: at "SYS.DBMS_SCHED ULER", line 374
          ORA-06512: at line 1

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

          SQLBEGIN
          2 DBMS_SCHEDULER. CREATE_JOB (
          3 job_name = 'daily_backup',
          4 schedule_name = 'dave.backup_sc hedule',
          5 job_type = 'executable',
          6 job_action = 'C:\OracleScrip ts\10g\full_bac kup.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
          OracleJobSchedu ler[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.

            Comment

            Previous template Next
            Working...