Home » Developer & Programmer » Forms » RefCode UJ001 : USER_JOBS . Instances Control using Hints
RefCode UJ001 : USER_JOBS . Instances Control using Hints [message #85745] Mon, 26 July 2004 11:20
Mauricio Fuenzalida
Messages: 4
Registered: July 2004
Junior Member
Hi,

My problems is :  I have a package that creates 10 instances of a PLSQL procedure.  This PLSQL uses the hint parallel,4.

I start the process, and 10 instances are stored into the USER_JOBS table.

If during the execution, the process has to be manually aborted, how can I ensure that nothing else will be running after kill the sessions stored in USER_JOBS ?. Currently I clean the user jobs with dbms_job.remove (job_id), but still there is instances appearing into my job queue.  I think that the hint is giving me problems.

 

Can you help me ?

I'll appreciate it

Thanks,

Mauricio

Report message to a moderator

Previous Topic: Getting REP-0503 error message when using run_report_object
Next Topic: password change after expiration
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Jan 31 21:43:33 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.