calling from one server to another

Original Message

Name: rajee
Date: March 22, 2006 at 08:30:36 Pacific
Subject: calling from one server to another
OS: UNIX
CPU/Ram: 256

Comment:

Hi,
I have a batch server where i need to run a script to call another script in the database server.The daabase server has the database and the batch only intiates the program and the shell in the database server exectues and extracts the data and store in the excel file...could anyone help in doing it ...could u give me some idea to do this ...tnxs in advance ...

Report Offensive Message For Removal

Response Number 1

Name: lchi2000g
Date: April 12, 2006 at 09:39:24 Pacific
Subject: calling from one server to another

Reply: (edit)

1. On DB server: (Oracle)
script: run.sh is as follows:
#!/bin/ksh
sqlplus $USERNAME/$PASSWORD@$CONNECT_STRING <<EOF
spool procress.sh
select ...
from ...
where ...;
spool off
host chmod 777 process.sh
host process.sh
EOF
2. On Batch server:
rsh <DB server hostname> -n [-l username] run.sh

Luke Chi

Report Offensive Follow Up For Removal


Ftp from Unix Server to Local machi rm files > 30 days to another dir to transfer files in unix add date to filename transfer data in unix platform	FTP Directories transfer dat-unix platform .maildelivery doesn't work on tru64 variables from one file to another telnet command to pop3 server