Problem with Job Scheduling

[s_jaideep]

Hi,

I am a new member in the group and I am facing very strange problem. I have created one package which has 9 procs and in one of the proc there is a query like this.
INSERT /* +apppend */ INTO pdb_extract.staging_smb_data
(SELECT ssdd.*
FROM pdb_extract.staging_smb_dhs_data ssdd
WHERE NOT EXISTS
(SELECT party_id
FROM pdb_extract.staging_dhs_excluded_subjectid sdes
WHERE
ssdd.party_id_person= sdes.party_id));

When I run this query directly on sql prompt it is executed with in 4 min.
But when we schedule this job , the process is stopped at this query and when I try to see the long operations it shows it will take more than 2000 hours to complete. I am also attaching the execution plan of the query when it is taking 2000 hours.
Please help me out !!!

Regards
Jaideep

[hrishy]

Hi

Can you post the init.ora parameter job_queue_processes and also the code that is used to run the dbms_job..

Did you include a commit after running the dbms_job ?

regards
Hrishy

[slimdave]

"/* +apppend */"?

[stmontgo]

you are scheduling through dbms_job?

can you

exec dbms_job.run() ?