Post reply

Run a zip batch file on a non-sql server from a SQL Agent job

  • June 12, 2008 at 11:33 am

    #122129

    Hello,

    I'm trying to run a DOS batch file (that zips a backup file) that exists on a server that has our FTP software on it. It doesn't have any SQL tools installed on it. The batch file runs and correctly zips the file. It also runs when logged in under the SQL Agent domain account.

    I've tried using a CmdExec step in a job, but it seems to be trying to run the bat file locally instead of on the other server even if the .bat file call is a URL. Is there a way to set the run directly?

    I've tried using an Exceute Process Task in an SSIS package using the same URL .bat stmt and get a message that URLs are not supported.

    I can execute the URL .bat stmt under my ID on my pc from the cmd prompt and it runs fine.

    Any help is apprecieated.

    ...thanks

  • June 12, 2008 at 12:01 pm

    #828040

    You need to use RCmd or another utility to remotely execute something.

  • June 12, 2008 at 2:27 pm

    #828116

    I'm researching RCmd, thanks for the help.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply