true they hv default values, but i think the Chris's runtime parameters are diff than his default values. ill try to give another look at it come monday.
> -----Original Message-----
> From: Scott Canaan [mailto:srcdco_at_RITVAX.RIT.EDU]
> Sent: Friday, December 13, 2002 10:39 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: warehouse builder's dependance on oem job system.
>
>
> I run the jobs via cron, without any parameters and we don't
> have any problems. If you look at the parameter list, you'll
> find that most (if not all) have default values anyway. I
> have been running them via cron for months without any
> issues, other than the fact that we can't multitask.
>
> "Mandar A. Ghosalkar" wrote:
>
> > Chris,
> >
> > the parameters 3,2,50,1000,50,wb,10 are used inside the
> oem-owb job tcl script as
> > set p_oper_mode [lindex $parList [incr parList_i]]
> > set p_audit_level [lindex $parList [incr parList_i]]
> > set p_num_errors [lindex $parList [incr parList_i]]
> > set p_commit_frequency [lindex $parList [incr parList_i]]
> > set p_bulk_size [lindex $parList [incr parList_i]]
> > set p_purge_group [lindex $parList [incr parList_i]]
> > set p_percentage [lindex $parList [incr parList_i]]
> >
> > and then the package.main is called
> >
> > try the following. i would recommend testing this on the
> test server before putting it on prod :-)
> >
> > sql>exec C40_ADMIN_CUSTOMER_MAP.Main(p_operating_mode => 3,
> p_audit_level => 2, p_max_errors => 50, p_commit_frequency => 1000,
> > p_bulk_size => 50, p_job => 'wb');
> >
> > -Mandar
> >
> > ----Original Message-----
> > Sent: Thursday, December 12, 2002 1:09 PM
> > To: Multiple recipients of list ORACLE-L
> >
> > here is the tcl that was generated:
> >
> > "-r" "3,2,50,1000,50,wb,10" "-c" "WE8MSWIN1252"
> >
> > the package that is generated is quite long.
> > i have absolutely no idea how to read the tcl.
> > if you could point me somewhere, i could try and figure it
> out myself.
> > any help is appreciated.
> >
> > attached is the package code if you are willing to take a look...
> >
> > (for some reason my computer associates .pls extensions
> with real audio)
> >
> >
> >
> >
> > -----Original Message-----
> > Sent: Tuesday, December 10, 2002 1:11 PM
> > To: Multiple recipients of list ORACLE-L
> >
> > Chris,
> >
> > All the owb etl jobs are packages and if you have
> configured it right, then you could the execute the
> package_name.main procedure to run the etl process. your best
> best would be to read the tcl script and the associated
> parameters for the owb-oem job.
> >
> > You could paste the tcl and the parameters here to help u more.
> >
> > -Mandar
> >
> > -----Original Message-----
> > Sent: Tuesday, December 10, 2002 9:31 AM
> > To: Multiple recipients of list ORACLE-L
> >
> > ok, here's the situation: we are loading our warehouse via
> etl processes generated by warehouse builder (owb). we went
> live with this a little over a week ago. up to this point we
> have been running the jobs manually through owb. for obvious
> reasons we need to be able to schedule these jobs. the only
> way (that i know of) to schedule the owb jobs is to deploy
> them to entreprise manager. the problem is that our oem is
> VERY unreliable and seems to be related to bugs. we are
> running oem v9.2 and oracle ee v9.2. when jobs are scheduled
> through oem, they run sometimes and hang others. this is
> unexceptable.
> >
> > so my question is: does anyone know of a way to trap the
> commands that oem sends to the database? the obvious
> solution would be to just cron execution of the packages owb
> generates inside the database. this doesn't work though
> because owb generates funky code that takes parameters, whose
> values i don't know, for logging purposes.
> >
> > hopefully i explained the situation well enough.
> >
> > any ideas??....i'd like to get rid of the dependance on oem.
> >
> > oem sucks
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Mandar A. Ghosalkar
> > INET: mghosalk_at_byer.com
> >
> > Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> > San Diego, California -- Mailing list and web
> hosting services
> >
> ---------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from). You may
> > also send the HELP command for other information (like subscribing).
>
> --
> Scott Canaan (srcdco_at_rit.edu)
> (585) 475-7886
> "Life is like a sewer, what you get out of it depends on what
> you put into it." - Tom Lehrer.
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Scott Canaan
> INET: srcdco_at_ritvax.rit.edu
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
>
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Mandar A. Ghosalkar
INET: mghosalk_at_byer.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Fri Dec 13 2002 - 19:18:44 CST
