DBMS_JOBS won't give you any "call back" that the function/procedure is finished, so it meens that the DBMS_JOBS system is "blind", then you cannot synchronize start of p2 while p1 is finished.And also, DBMS_JOB won't return any function return value !