Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: scripting question
My problem is that the only way that I can connect to the machine that has the data is through telnet. I highly doubt that the Unix admin for that machine will want to grant me auto-login access. Does this bring me back to using expect?
Matt
"Dan" <dank_the_anti_spam_man_at_ihug.com.au> wrote in message
news:QoO86.199$yN2.5315_at_ozemail.com.au...
> I would look into 'cron'
> You don't need to telnet into nothing. Just set up cron to run the sql
> script at whatever times you want.
>
> Dan
>
> "Matt Gross" <mattgross_at_NOSPAMyahoo.com> wrote in message
> news:t674no3roskg84_at_corp.supernews.com...
> > I have a question about building a script. Here is what I need the
script
to
> > do. First, I need it to login to another unix machine (is this through
> > telnet?) and then on that machine I need it to somehow log into sqlplus
and
> > execute a *.sql script. Does anyone know how I can do this? Finally, I
will
> > need to set this up to run every morning at say around 8 am. Can anyone
help
> > with this or at least point me in a direction to search for info?
> >
> > Thanks,
> >
> > Matt
> >
> >
>
>
Received on Tue Jan 16 2001 - 13:43:19 CST