First of all, welcome to the Monastery, and I hope you find it both helpful and enjoyable to visit here.

Now, to your question. First of all, I would suggest using the DBI module to make connections to the database, then you can just execute the SQL commands you have (there are some articles in the Tutorials section which may also be helpful in looking at that). You can also use Net::FTP for handling the FTP connection (although it might also be possible for your to install the appropriate modules on the remote machine and run the script from there, eliminating the FTP requirement-just a thought).

HTH.

In reply to Re: Waiting for an SQL script to finish by atcroft
in thread Waiting for an SQL script to finish by LeeC79

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.