Thursday, February 23, 2017

SQL Agent Job failed - /CALLERINFO "SQLAGENT" /REPORTING "E" " has mismatched quotes

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