Re: dbms_scheduler - external job problems

  • From: brian.x.wisniewski@xxxxxxxxxxxx
  • To: mdemenko@xxxxxxxxx
  • Date: Thu, 6 Apr 2006 09:37:19 -0400

I used the GUI to perform the upgrade.  I finally found something very 
late last night in the Application Server Admin Guide (10.1.2) of all 
places that talks about creating windows services.  It appears I have to 
have the SC tool from the Windows Resource Kit!

job scheduler 
sc create OracleJobScheduler<oracle_sid> start= auto 
binPath= "ORACLE_HOME\bin\extjob.exe <oracle_sid>"
For example:
sc create OracleJobSchedulerORCL start= auto 
binPath= "INFRAHOME\bin\extjob.exe <oracle_sid>"
Note: oracle_sid should be in upper case



Brian S. Wisniewski
Sr. Oracle Database Administrator
Central Technology Infrastructure & Operations
brian.x.wisniewski@xxxxxxxxxxxx
Cell: 614.975.2905




Maxim <mdemenko@xxxxxxxxx>
Sent by: oracle-l-bounce@xxxxxxxxxxxxx
04/06/2006 03:04 AM
Please respond to mdemenko
 
        To:     "brian.x.wisniewski@xxxxxxxxxxxx" 
<brian.x.wisniewski@xxxxxxxxxxxx>
        cc:     oracle-l@xxxxxxxxxxxxx
        Subject:        Re: dbms_scheduler - external job problems


That's interesting, i'll try to reproduce it. 
No, i don't know how to fix it, sounds like a bug - i would open a TAR. 
How did you upgraded - via gui or per script ?

Best regards

Maxim

On 4/6/06, brian.x.wisniewski@xxxxxxxxxxxx <
brian.x.wisniewski@xxxxxxxxxxxx> wrote: 

Thanks - that helped.   

Do you know how to create the JobScheduler service if there isn't one?  On 
the 10g databases I created as 10g from the start - the service is there 
and disabled.  However on the 9i databases that were upgraded to 10g the 
service is not present and I can't find documentation anywhere that talks 
about creating this service. 




Other related posts: