Oracle Warehouse Builder (OWB) Weblog

Batch unload and remote agents

By david.allan on September 26, 2008 11:02 AM

This post illustrates natively unloading from other database systems such as Microsoft SQL Server using the Oracle 11g database scheduler's remote agent. This is all driven from the database via PLSQL api calls. The package relies on installing the lightweight...

Comments (1) | TrackBacks (0)

Event Based Execution - File Arrival Example

By david.allan on September 8, 2008 2:38 PM

If you want to do truly event based execution based on arrival of a file there is a convenient package supplied with the Oracle database scheduler component that can be used, the package can be downloaded from OTN here. For...

Comments (1) | TrackBacks (0)

11g Remote Agent

By david.allan on March 11, 2008 11:16 AM

Some more cool stuff in 11g, the Gateways install has a lightweight remote/scheduler agent for executing tasks such as native unloaders or any custom activity. This follows on from the post on the 11g Heterogeneous Agent, and the agent is...

| TrackBacks (0)