| Prioritizing oracle scheduled jobs [message #303086] |
Wed, 27 February 2008 23:06  |
harikrish
Messages: 4
Registered: February 2008
Location: India
|
Junior Member |
|
|
Hi,
Two applications are sharing same database - Oracle 9i [having different schema].
In first application we have scheduled a job which runs daily. This job inturn will submit 3000 jobs using DBMS_JOB.SUBMIT();.
The second appliaction submit jobs from UNIX. When we see the priority of these jobs it is always lesser than those that are submitted from first application.
Please let me know is there a way to prioritize jobs in Oracle 9i.
Thanks
Hari
|
|
|
|
|
|
|
|
|
|
| Re: Prioritizing oracle scheduled jobs [message #303193 is a reply to message #303189] |
Thu, 28 February 2008 05:07  |
harikrish
Messages: 4
Registered: February 2008
Location: India
|
Junior Member |
|
|
Another doubt...
As I told in my previous message.
1. One application is having a job schedule in oracle which in turn submits 3000 jobs using dbms_job.submit().
2. Another application submit jobs from UNIX.
My doubt:
If we make the first application to kick off the parent job from UNIX (instead of scheduling from Oracle) will all the child jobs (the 3000 jobs that are submitted using dbms_job.submit) get same priority what the job that getting in second application(submitted from UNIX)?
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
