Hi,

I could replicate the issue you are facing the copying the template query and pasting it in command prompt after making the required changes.

Workaround: Just type the whole command in...

You can run a Sql Command in the scheduled job to do the desired task for you. Following is the syntax for the same.

SQLCMD -S YourSQLServer -d YourDatabase -U YourUserName...