Re: dbms_scheduler - external job problems

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_at_jpmchase.com
Cell: 614.975.2905

Maxim <mdemenko_at_gmail.com>
Sent by: oracle-l-bounce_at_freelists.org
04/06/2006 03:04 AM
Please respond to mdemenko  

        To: "brian.x.wisniewski_at_jpmchase.com" <brian.x.wisniewski_at_jpmchase.com>

        cc:     oracle-l_at_freelists.org
        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_at_jpmchase.com < brian.x.wisniewski_at_jpmchase.com> 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.

--
http://www.freelists.org/webpage/oracle-l