Home » SQL & PL/SQL » SQL & PL/SQL » Prioritizing oracle scheduled jobs
Prioritizing oracle scheduled jobs [message #303086] Wed, 27 February 2008 23:06 Go to next message
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 #303102 is a reply to message #303086] Thu, 28 February 2008 00:12 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
There is none.

Regards
Michel
Re: Prioritizing oracle scheduled jobs [message #303189 is a reply to message #303102] Thu, 28 February 2008 05:01 Go to previous messageGo to next message
harikrish
Messages: 4
Registered: February 2008
Location: India
Junior Member
Do we have dbms_scheduler in Oracle 9i?

Re: Prioritizing oracle scheduled jobs [message #303191 is a reply to message #303189] Thu, 28 February 2008 05:05 Go to previous messageGo to next message
pablolee
Messages: 2835
Registered: May 2007
Location: Scotland
Senior Member
read
Re: Prioritizing oracle scheduled jobs [message #303193 is a reply to message #303189] Thu, 28 February 2008 05:07 Go to previous messageGo to next message
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)?
Re: Prioritizing oracle scheduled jobs [message #305193 is a reply to message #303193] Mon, 10 March 2008 01:50 Go to previous message
harikrish
Messages: 4
Registered: February 2008
Location: India
Junior Member
Any help om this?
Previous Topic: Usage of package on a dynamically provided table name.
Next Topic: Exponential values in oracle.
Goto Forum:
  


Current Time: Thu Dec 08 19:54:42 CST 2016

Total time taken to generate the page: 0.24746 seconds