* How do you need to schedule an OWB ETL job with OEM?

1. The ORACLE Management Server must be running on the target server where
   the runtime platform service is installed.
   The OEM repository must be created first with "OEM repository assistant"
   for the management server to run. Apparently the management server can
   find the repository owner info. and log in automatically.
   On WindowsXP, the service name is "Oracle<ORACLE_HOME>ManagemnetServer"

2. The OEM intelligent agent must be running.
   On WindowsXP, the service name is "Oracle<ORACLE_HOME>Agent"

3. "Preferred credentials" must have been set on both the node and the database.
   On NT, the node user must have "log on as a batch job" privilege.
   On Win XP home, where no network has been set up. Go to control panel/user account
   and edit or create the user info.. Password must be set. OK for the user name
   to have space like "Jusung Yang"

4. Log on to OEM console with an user that has operating system privileges
   to run batch jobs. Use SYSMAN if you are not sure. Check the "help" button
   for the default password for SYSMAN.

5. The mappings or the process flows must have been "deployed".

6. Create a job in OEM:
   Select the DW database ans the target.
   Select "Run SQL*PLUS Script" as the task
   Import a script oem_exec_template from <OWB home>\owb\rtp\sql
          and use the following parameters:
          - Runtime Repository Owner
          - Target location
          - Task Type: either one of the PL/SQL, SQL_LOADER, or PROCESS.
          - Task name (name of the mapping/process flow)
          - System parameters (comma separated, enclosed by double quotes; comma and \can be escaped by \)
          - Custom parameters (see system parameters) 

   For example:
       OWB_RT_REPO PlatformSchema SQL_LOADER MAP1 "," ","

   For SQL_LOADER, the location is always "PlatformSchema"
   Note that they are all "Case Sensitive", for now, with 9.0.4

   You can actually run it from SQL*PLUS first to find out what's going on:
      @d:\oracle\owb\owb\rtp\sql\oem_exec_template.sql OWB_RT_REPO PlatformSchema SQL_LOADER MAP1 "," ","


*** If the OEM jobs remain in the "submitted" status and do not seem to be executing,
*** stop and restart the ORACLE agent service.

** On a successful job run, you should see something like this in the OEM.

SQL*Plus: Release 9.2.0.1.0 - Production on Mon Jun 30 18:23:37 2003

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

Enter user-name: 
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production


Session altered.

SQL> 
Session altered.


Role set.

Stage 1: Decoding Parameters
|  location_name=PlatformSchema
|  task_type=SQL_LOADER
|  task_name=M_COUNTRY
Stage 2: Opening Task
|  l_audit_execution_id=1170
Stage 3: Overriding Parameters
Stage 4: Executing Task
|  l_audit_result=1 (SUCCESS)
Stage 5: Closing Task
Stage 6: Processing Result
|  exit=0

PL/SQL procedure successfully completed.

Disconnected from Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production