If folded/file path contains spaces in SQL Agent parameter, you might get an error something like below.
/CALLERINFO "SQLAGENT" /REPORTING "E" " has mismatched quotes. The command line parameters are invalid. The step failed.
For example, the below path contains a space “Process Files”
\\svr1\c$\Process Files\Sale\
To solve this problem, just use a double backslash in the end of the pathname. Yes, it will work ☺
\\svr1\c$\Process Files\Sale\\
Cheers!
Uma
helped me thanks
ReplyDeleteThat was very interesting. Thank you for this update
ReplyDelete