RUNNING MULTIPLE INSTANCES IN PARLLEL

[anandkumarm]

Hi
I have a job that extracts data from a table in oracle database and puts it into a dataset.this job takes the a parmeter 'period' SAY 'apr-07' and runs the job.
we have to extract the data for n number of such periods.The table is very huge and is not partioned so we were extracting the data for the period values.
if i extract for all these periods one after the other it is taking lot of time .
so we wanted to run each period parllel to the other one..so that the job can take the same time for all the periods together as it takes for one period.
how can I use multiple instances in this situation for pallel jobs??how can I pass the invocation id for a parllel job??
is there any other way to handle the situation??

[kris]

You both are working on the same task?

The other person already started a thread on the same topic.

http://dsxchange.com/viewtopic.php?t=11 ... 006ccfe017

Best regards,