OutFile in SQL Agent

  • Is there possibility for a SQL job to output file to two different paths in Advanced Option in the Job step?

  • PJ_SQL - Friday, May 5, 2017 11:47 AM

    Is there possibility for a SQL job to output file to two different paths in Advanced Option in the Job step?

    Don't think so but you could try adding another step to copy the file to another location.

    Sue

  • PJ_SQL - Friday, May 5, 2017 11:47 AM

    Is there possibility for a SQL job to output file to two different paths in Advanced Option in the Job step?

    That's a definite no.   If you want an output file from some process to end up in more than one destination, then either modify that process to deposit it's output into multiple locations, or add another job step to copy the file to the other location.

    Steve (aka sgmunson) 🙂 🙂 🙂
    Rent Servers for Income (picks and shovels strategy)

  • Thank you all.

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

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