• The cmd file works no problem from the command line


    You are running the file locally or on the remote system? I don't know anything about Putty and, in your example syntax there is no reference to a remote machine.

    Host does not exist. Unable to open connection


    That's the kind of error you get when:
    1. You're putting in the wrong host name
    2. You're putting in the correct host name but you're having DNS issues (temporarily using the host's IP address is a good way to test this)
    3. You're putting in the correct host name, it's DNS name is being resolved correctly, but a port is not open
    4. The SQL Agent account you're using does not have access to a system (sometimes people set the error that way for security: this vs letting hackers know they've found a live system but don't have access).

    Also note that, local admin rights doesn't give an account access to a remote system that it doesn't otherwise have access to.

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001