Forum Replies Created

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

  • RE: SQLCMD mode in a job step?

    That was awsome. Thank you so much

  • RE: SQLCMD mode in a job step?

    you don't need to add the -E parameter if you don't specify password and username. it uses windows authentication by default.

    I got it to run when i changed this...

  • RE: SQLCMD mode in a job step?

    "Yes, you can do it.

    Create "Operating system" type job step: "sqlcmd -S SQLSRV -i C:\Tests\TestCMD.sql"

    example of TestCMD.sql file :

    :Setvar BackFldr "C:\TestCMD\"

    !!if exist C:\TestCMD\*.bak (move K:\TestCMD\*.bak K:\TestCMD\ARCHIVE\) ELSE (ECHO No files...

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