I have a SQL agent job (test.sql) which is on server10.
I have a source file(Dummy_Test) in AB folder\srcfiles, I need to move that to AB\TgtFiles. This folder is located on server 11.
How can I move them? Please help
I am using and running sql agent job test.sql on server10 which has below mentioned code in one of the step.
move '\\server11.a.b.com\shared\AB\SrcFiles\Dummy_Test' '\\server11.a.b.com\shared\AB\TgtFiles\Dummy_Test'
--- It says syntax error.
Please help, is it possible to do this? or am I missing something?