How to run a Unix script from another server ??
Moderators: chulett, rschirm, roy
How to run a Unix script from another server ??
From DataStage (which is on one server), how do you run a unix script from Oracle (which is on another server)?
Use a call to UNIX shell script and use rsh.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Premium Member
- Posts: 252
- Joined: Mon Sep 19, 2005 10:28 pm
- Location: Melbourne, Australia
- Contact:
...how do you run a unix script from Oracle
Taking you literally, to run a Unix script from Oracle, see http://www.orafaq.com/forum/mv/msg/5517 ... msg_147495
In short, it's easy on Oracle 10g using DBMS_SCHEDULER package, trickier otherwise because you have to write you own launcher in C and hook it into PL/SQL. Once you get a PL/SQL stored procedure calling your script, just call the stored proc from the after-sql of the OCI stage with
Code: Select all
call proc_name(args)
Ross Leishman