dbms_job.submit
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: dbms_job.submit

  1. #1
    Join Date
    Jun 2001
    Posts
    76
    All -

    I have tried, to no avail to schedule jobs within the database using dbms_job.submit. Code is as follows:

    SQL> variable jobNo number;
    SQL> begin
    2 dbms_job.submit(:jobNo,
    3 'sp_summary_table_population;',
    4 trunc(sysdate)+0.333,
    5 'trunc(sysdate+1)+0.333');
    6 commit;
    7 end;
    8 /

    This returns successfully, but the procedure does not run. I have tried every variation I can think of... Is there something fundamentally I am doing wrong? According to the user_jobs table, it is scheduled to run at 7:59:31AM, but it does not run at all... any suggestions?

    Thanks,

    R
    On the other hand, you have different fingers.

  2. #2
    Join Date
    Jul 2000
    Posts
    296
    Is init.ora parameter JOB_QUEUE_PROCESSES set to 1 or higher?

  3. #3
    Join Date
    Jun 2001
    Posts
    76
    job_queue_processes was not in the init.ora file, so I added it with a value of 1. I tried again to schedule, but it did not work, so I increased the value by one and tried again to no avail. Any suggestions?

    R
    On the other hand, you have different fingers.

  4. #4
    Join Date
    Jan 2001
    Posts
    2,828

    Talking

    Hello

    I think after makin changes to init.ora you forgot to bounce back the database.

    regards
    hrishy

  5. #5
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    do

    alter system set JOB_QUEUE_PROCESSES = 2

  6. #6
    Join Date
    Jun 2001
    Posts
    76
    A thousand "thank you"'s. for whatever reason, the alter system... command did what editing the init.ora file did not.

    Thanks,

    R
    On the other hand, you have different fingers.

  7. #7
    Join Date
    Aug 2001
    Posts
    134

    Hi
    when i run the block the error occurs
    ORA-06512: at "SYS.DBMS_JOB"
    Can i run any script file ?
    Please write the name.
    Thanx

Posting Permissions

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


Click Here to Expand Forum to Full Width