I am looping over a cursor and executing a stored procedure; how do I parallelize this process through dbms.jobs?
for rec in select column from table1 loop execute stored_procedure( rec.column ); end loop;
The pl/sql package DBMS_PARALLEL_EXECUTE can be used to parallelize pl/sql. Examples can be found in the manual. You can use the first example (Chunk by ROWID):
define a procedure
and then (following the example) write a job that does the following