You can see if a job is running in Oracle by checking against the user_jobs table for the exact name of what you are running, for example:
SELECT COUNT(uj.job)
INTO v_running
FROM user_jobs uj
WHERE uj.what = 'myschema.mypackage.myproc;';
You can see if a job is running in Oracle by checking against the user_jobs table for the exact name of what you are running, for example:
SELECT COUNT(uj.job)
INTO v_running
FROM user_jobs uj
WHERE uj.what = 'myschema.mypackage.myproc;';