• If I insert variable in SQL JOB Step, the JOB exec stopped with error.

    When I insert throughout code (variables, bcp command...) in .bat file, and I reference this file in SQL JOB, the JOB was successfully executed.

    This is very interesting! Why get error, if code in JOB step, and why not if code insert in .bat file?

    Sorry for my english!

    Thanks

    gmac