dbms_job [message #486267] |
Tue, 14 December 2010 09:59 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
prashant_ora
Messages: 196 Registered: July 2010
|
Senior Member |
|
|
I am creating 5 dbms_job at run time in side a stored procedure.But when I execute that procedure, all the job get 100%cpu and as a result other process does not get response. so my question is can we limit the dbms_job to use a defined amount of cpu%.
Thanks
|
|
|
|
|
|
Re: dbms_job [message #486296 is a reply to message #486285] |
Tue, 14 December 2010 11:57 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
prashant_ora
Messages: 196 Registered: July 2010
|
Senior Member |
|
|
suppose i create 10 jobs at a time, so is there any way to create depndency so that when first job complete then only second job will start and once the second will finish then third one will start and so on.
|
|
|
|
Re: dbms_job [message #486304 is a reply to message #486298] |
Tue, 14 December 2010 12:14 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
prashant_ora
Messages: 196 Registered: July 2010
|
Senior Member |
|
|
If i submit 10 jobs at a time and in every job one common proc is calling with different parameter, so my question is that whethere all the 10 jobs use the same session to call the proc or they create different different session and call the proc.
|
|
|
|
Re: dbms_job [message #486307 is a reply to message #486296] |
Tue, 14 December 2010 12:25 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68678 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
prashant_ora wrote on Tue, 14 December 2010 18:57suppose i create 10 jobs at a time, so is there any way to create depndency so that when first job complete then only second job will start and once the second will finish then third one will start and so on.
I don't know if this is possible with new scheduler jobs but it is not by default with old jobs.
Why not submit the next job from the previous one instead of submitting all the jobs in the first procedure?
You can also submit all jobs in the original procedure but in broken state and change it to "not broken" in the previous job.
You can also use "signals" (see dbms_alert).
And so on, there are so many ways to do it.
Regards
Michel
[Updated on: Wed, 15 December 2010 14:52] Report message to a moderator
|
|
|
Re: dbms_job [message #486462 is a reply to message #486307] |
Wed, 15 December 2010 14:23 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
|
If your OS is UNIX then you can take the help of shell script as well.
But jobs will be executed in different session.
Regards,
Hara
|
|
|