 |
| Error you get when you try to create a new Calendar Module in OWB 11g without Data Integrator EE license |
You can still schedule jobs by using a SQLPlus script which can then be called in a .bat or Shell script and scheduled using Windows Scheduler or Crontab in Unix.
In OWB 11g, we can find a SQL script ready to use in [OWBHOME]\owb\rtp\sql. The script you need is called: sqlplus_exec_template.sql
The script can be executed only by a Workspace Owner or a Workspace user with Execute privileges.
The script uses the following parameters:
- WORKSPACE Workspace in which the job is to run: e.g. MY_WORKSPACE Make sure you specify the right Workspace Name. You can check it by executing:
SELECT * FROM ALL_IV_WORKSPACES
- LOCATION_NAME Physical Name of the Location to which this task was deployed: e.g. MY_WAREHOUSE
- TASK_TYPE
- PLSQLMAP - OWB PL/SQL Mapping
- SQLLOADERCONTROLFILE - OWB SQL*Loader Mapping
- PROCESSFLOW - OWB ProcessFlow
- ABAPFILE - OWB SAP Mapping
- DATAAUDITOR - OWB DataAuditor Mapping
- SCHEDULEDJOB - OWB Scheduled Job
- CTMAPPING - OWB Template Mapping
- TASK_NAME Physical Name of the Deployed Object.e.g. MY_MAPPING. Make sure you specify the TASK_NAME in the following format: [PARENT_TASK]/TASK_NAME
- SYSTEM_PARAMS { , | (name = value [, name = value]...)}
- CUSTOM_PARAMS { , | (name = value [, name = value]...)}
SQL> @sqlplus_exec_template.sql MYWKS WFS_LOCATION PROCESSFLOW "DIM_FACT
/DIM_ALL" "," ","
The script calls functions from the OWBSYS.wb_rt_script_util package so you may need to grant the right privilege to the OWB User.
