AnsweredAssumed Answered

Has anyone ran into a issue when you use the {Variable,keyword,value} in the SQL tab?

Question asked by TravisBoaz601354 on Nov 17, 2015
Latest reply on Nov 25, 2015 by LeonCarroll610975
I can execute the job and it uses the right server but if I just want to use the dropdown list from Forms tab to verify the sql job is there I get an  The TCP/IP connection to the host {VARA.ICW_SERVERS,SIMS_DEV,1}, port 1433 has failed. Error: "null. Verify the connection properties, check that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port, and that no firewall is blocking TCP connections to the port.   It does not seem to use the server name in the that variable table.  I can hard code the server into the server field and the dropdown in the forms tab will list the appropriate job lists.

Outcomes