I have used bind variable before in automation scripts but can’t seem to get this one to work. Could it be the ODBC connection? It works when I run the SQL not in the job and answer the prompt.
TES.log (11.6 KB)
What is this prompt you are referring to? What database type is this ODBC connection connecting to?