Home » Developer & Programmer » Application Express, ORDS & MOD_PLSQL » DBMS_JOB for parallel processing
icon5.gif  DBMS_JOB for parallel processing [message #186248] Mon, 07 August 2006 03:02
quest_nisha
Messages: 4
Registered: August 2006
Location: Bangalore
Junior Member
HI,
I am trying to tune an application which is taking 8hr's. Can I use dbms_jobs to parallel process the application..

I am trying something like this, application has to process for 11 templates in parallel.. and finally insert the data calculated in a common table...


FOR record IN cursor LOOP
EXIT WHEN cursor%NOTFOUND; /* record contains 11 templates */
dbms_job.submit( job => vJob,
what => 'Procedure(--);',
next_date => SYSDATE );
commit;
END LOOP;

But the application doesnt run after using dbms_job..i.e no record are inserted in the final table.. the user_jobs tables shows that the jobs failed..
Is there anything I am missing here..????
What are the risks involved in using jobs???
Previous Topic: Getting Username
Next Topic: How can I set the column with by the Oracle Application Server
Goto Forum:
  


Current Time: Thu Mar 28 20:20:47 CDT 2024