InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comFri, 24 May 2013 10:06:24 GMT20http://www.sqlservercentral.com/Forums/Topic919407-146-1.aspxThat was awsome. Thank you so muchTue, 29 Jan 2013 08:00:44 GMTtomiapihttp://www.sqlservercentral.com/Forums/Topic919407-146-1.aspxTry -Q instead of -qTue, 29 Jan 2013 06:50:01 GMTmagasvshttp://www.sqlservercentral.com/Forums/Topic919407-146-1.aspxyou 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 : "sqlcmd -S SQLSRV -i C:\Tests\TestCMD.sql"to this: sqlcmd -S SQLSRV -q "C:\Tests\TestCMD.sql"I executed a tiny query that respond on the Command promt console inmediatly but my Job starts running and never finishes.. has this happened to you ? thanksTomTue, 29 Jan 2013 06:08:15 GMTtomiapihttp://www.sqlservercentral.com/Forums/Topic919407-146-1.aspxYou can use Windows authentication - you need to add -E parameter (no need to use username and password).Mon, 28 Jan 2013 20:10:56 GMTmagasvshttp://www.sqlservercentral.com/Forums/Topic919407-146-1.aspx"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 found)"My job is not working don't you need to specify user and password for sqlserver?Fri, 25 Jan 2013 13:20:28 GMTtomiapihttp://www.sqlservercentral.com/Forums/Topic919407-146-1.aspxI guess its close, thanks for your inputTue, 11 May 2010 17:04:54 GMTglugingboulderhttp://www.sqlservercentral.com/Forums/Topic919407-146-1.aspxYes, 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 found)Tue, 11 May 2010 08:28:22 GMTmagasvshttp://www.sqlservercentral.com/Forums/Topic919407-146-1.aspxIs there anyway to get SQLCMD mode to run in a job step?I find it a quick method to execute *.sql scripts with :r "C:\path\file.sql"Also quick access using !! to execute cmdshellI know there are methods using xp_cmdshell just not as elegant as SQLCMD mode in query editorMon, 10 May 2010 21:06:55 GMTglugingboulder