Oracle-L: RE: warehouse builder's dependance on oem job system.

From: Chris Stephens <ChrisStephens_at_affina.com>
Date: Tue, 10 Dec 2002 12:49:32 -0800
Message-ID: <F001.00516D58.20021210124932@fatcity.com>

no we aren't using workflow. last time i checked, that was very buggy too. i.e. the dependancies could not be verified so all the jobs executed regardless of whether or not the conditions of execution were met. i could be wrong about that though. ...we don't really need owf as of yet.

also oracle support provided me with the following note:

Note: 91833.1

....i'll let you know how it turns out.

-----Original Message-----
Sent: Tuesday, December 10, 2002 1:15 PM To: Multiple recipients of list ORACLE-L

You may have implied this in your message, but are you using Oracle Workflow in conjunction with OEM? That is the scheduling method that is taught in the OWB class by Oracle.

I am currently learning OWB but have not setup scheduling yet, so I'd be interested to hear your solution once you find it.

Best regards,

David B. Wagoner

Database Administrator

Arsenal Digital Solutions Worldwide, Inc.

8000 Regency Parkway, Suite 100

Cary, NC 27511-8582

Office (919) 466-6723

Mobile (919) 412-8462

Pager 8666864767_at_archwireless.net

Fax (919) 466-6783

AIM adswDavid

<http://www.arsenaldigital.com/> http://www.arsenaldigital.com/

NOTICE ***

This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify the sender by phone or email and delete this e-mail message from your computer. Thank you.

-----Original Message-----
Sent: Tuesday, December 10, 2002 12:31 PM 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: Chris Stephens
INET: ChrisStephens_at_affina.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 Tue Dec 10 2002 - 14:49:32 CST