Results 1 to 1 of 1
  1. #1
    Join Date
    Aug 2008
    Posts
    464

    Unanswered: Duplicate - please ignore

    Hi

    Will appreciate some advice on DBMS_SCHEDULER jobs.

    I created and then verified the creation of a PROGRAM in dba_scheduler_programs.

    Code:
    BEGIN
    DBMS.SCHEDULER.CREATE_PROGRAM (
    PROGRAM_NAME => 'PROG_01'
    , PROGRAM_TYPE => 'STORED_PROCEDURE'
    , PROGRAM_ACTION => 'SCHEMA.PACKAGE'
    , ENABLED => TRUE);
    END;
    Code:
    BEGIN
    DBMS.SCHEDULER.CREATE_SCHEDULE (
    SCHEDULE_NAME => 'SCHEDULE_01'
    , REPEAT_INTERVAL => 'FREQ=MINUTELY; INTERVAL=1');
    END;
    Code:
    BEGIN
    DBMS_SCHEDULER.CREATE_JOB (
    JOB_NAME => 'JOB_01'
    ,PROGRAM_NAME => 'PROG_01'
    , SCHEDULE_NAME => 'SCHEDULE_01'
    , ENABLED => TRUE);
    END;
    I can see the job in USER_SCHEDULER_JOBS.

    But when I try to run the job manually:

    Code:
    EXECUTE DBMS_SCHEDULER****N_JOB ('SCHEMA.JOB_01',TRUE);
    I get

    Code:
    ORA-06576: Not a valid function or procedure name.
    NOTE: This is the second time I'm having to create this job. The first time round, it was successful but then I removed it by mistake.

    Don't see why I'm getting this error this time!!
    Last edited by shajju; 02-24-13 at 09:32.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •