Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
joyce.hughes
Starting Member
1 Post |
 Posted - 2014-07-02 : 13:54:40
|
| Please help. I am pulling my hair out!I have tried various commands in my step for a job and keep getting variouos errors. (I did the following from a command prompt in SQL)ex: robocopy d:Imports d:Imports\OLD Import*.xls /MOVerror: Msg 102, Level 15, State 1, Line 2Incorrect syntax near 'Imports'.Msg 132, Level 15, State 1, Line 2The label 'd' has already been declared. Label names must be unique within a query batch or stored procedure.(I did the command within the Step)ex: robocopy "D:Imports Import*.*" "D:\Imports\OLD\*.*" /MOVerror: MessageExecuted as user: NMED\nmcsd.devsql. The process could not be created for step 3 of job 0x099906A8D9C57C419BA713A29DF9022C (reason: The system cannot find the file specified). The step failed.The path for the file is D:\ImportsThe destination path is D:\Imports\OLDI want to move the file from Imports to OLD, then delete it from Imports. I would appreciate any help. Thanks. |
|
|
James K
Master Smack Fu Yak Hacker
3873 Posts |
Posted - 2014-07-02 : 14:05:46
|
Since you are getting errors when you try to run the command line, that needs to be fixed first. Don't you need a back slash? E.g., instead ofrobocopy d:Imports d:Imports\OLD Import*.xls /MOV this:robocopy d\:Imports d\:Imports\OLD Import*.xls /MOV |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2014-07-02 : 14:06:40
|
| robocopy d:\Imports d:\Imports\OLD *.xls /MOVTara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
SQL Server Agent Error
Tara Kizer