Link to home
Start Free TrialLog in
Avatar of gudii9
gudii9Flag for United States of America

asked on

'ssh' to the server and run the SQLPlus to send output to text file

I am having issue with database administration team to turn on listener for a particular database to display data in my perl application. So alternatively i would like to connect to the database wth perl through  'ssh' to the server and run the SQLPlus and run couple of queriees and send the the output back to the text file. The perl application uses the same query. How can i achieve this. Any resources, links, ideas highly appreciated. thanks in advance
Avatar of tangchunfeng
tangchunfeng

crontab + sqlplus -> output file -> perl + ftp
Avatar of gudii9

ASKER

what is 'crontab' you are referring.

>>crontab + sqlplus -> output file -> perl + ftp

can you please elaborate on this, I am not clear on this


 Please advise
ASKER CERTIFIED SOLUTION
Avatar of tangchunfeng
tangchunfeng

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of gudii9

ASKER

can you please provide me the sample code, links, resources of the crontab to do that job. Does it SSH also automatically. Or after SSH we have to run the cronjob. please advise
Avatar of gudii9

ASKER

is CRON job is same as crontab. Are they different please advise
SOLUTION
Avatar of David VanZandt
David VanZandt
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial