Security & Virus | Hardware | Windows XP | Windows Vista | PC Gaming

calling from one server to another

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 ...

Name: lchi2000g
Date: April 12, 2006 at 09:39:24 Pacific

Reply:

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

0

Pushing carriage return i...

num not identified when u...

Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.

Summary: hi, Can some one help me to automate ftp from unix server to local machine? I have a shell script from which I want to ftp log file to pc. Thanks ...

Summary: I have written a script to automatically ftp a file from one server to another. I want to add the date and time to the extension of my file name. If my script has target_name=library. how do I add...

Summary: thommym, thanks for the correction. excuse me for the confusion, new to the unix world... i just want to move the files from one directory to another directory base on the 30 day rule. find /full/pat...