Results 1 to 5 of 5
  1. #1
    Join Date
    Apr 2002
    Posts
    4

    Unanswered: Execute ftp script

    Hi !

    We have a sql 2000 with sp2.

    We wan't to execute a *.cmd file with a ftp command.
    The ftp.cmd file is working ok interactive.
    But if add it to enterprice manager/SQL Server Agent/Jobs we get failed.

    Here are the cmd file:

    @echo off
    del d:\mtdaxel\ftppmlogg.txt

    date /T >> ftppmlogg.txt
    time /T >> ftppmlogg.txt

    ftp -n -s:ftppm.ftp >> ftppmlogg.txt
    exit

    Any sugestion "please" for our problem.

    Regards Jan Rockstedt
    Attached Thumbnails Attached Thumbnails ftpsql.gif  

  2. #2
    Join Date
    Feb 2002
    Posts
    2,232
    Have you tested this script outside of SQL Server Agent jobs ?

    The message you are receiving indicates that something is invalid with your ftp statement. The only thing that might be incorrect in your statement is the filename "ftppm.ftp". Since you are not using an absolute path, when the agent runs the job the path is probably incorrect. Try using an absolute path.

    Good luck.

  3. #3
    Join Date
    Apr 2002
    Posts
    4
    Yes i have test it outside.

    I will try the absolute path tomorrow.

    Thanks !!!!

    //Jan

  4. #4
    Join Date
    Apr 2002
    Posts
    4
    Yes it was the path.

    Thanks rnealejr !!!!


  5. #5
    Join Date
    Apr 2002
    Posts
    4
    Yes it was the path.

    Thanks rnealejr !!!!


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •