Results 1 to 1 of 1
  1. #1
    Join Date
    Sep 2003
    Posts
    33

    Unanswered: Very urgent: DBMS_JOBS

    Hi

    I hv submitted a job like this to execute it everyday at 7.00AM.


    create or replace procedure DBMS_HOLIDAY_JOB
    as
    jobHoliday number;
    begin
    dbms_job.submit(
    jobHoliday, 'HolidayAssign.checkHoliday;',
    trunc(sysdate)+7/24,
    'SYSDATE+1');
    commit;
    end;
    /

    exec DBMS_HOLIDAY_JOB;


    But it was not executed at 7.00am...what cud be the pbms....any solutions or change in teh script?

    Here HolidayAssign is a package and checkHoliday is a procedure. My environment is windows NT and Oracle 9.2.0

    In init.ora file parameters are

    JOB_QUEUE_PROCESSES=10
    Last edited by kondaoracle; 10-06-03 at 21:12.

Posting Permissions

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