Getting error while connecting to another database as- There is already an open transaction on this connection.Have to create a new connection

Which version are you using? 

Can you please elaborate in bit more detail what you are trying to do, as you cannot really execute a job in Designer. 

Thanks for responding..

I am using Designer V8. I have created a process in Designer, the prime task of the process is to create a connection to another database and import data from there into UNS Account B table , While executing the Job , In Job Que I am getting the error as mentioned above, if I am trying to fire the job multiple times.

Please let me know how to close the transaction if one is already running for that.

Thanks for responding..

I am using Designer V8. I have created a process in Designer, the prime task of the process is to create a connection to another database and import data from there into UNS Account B table , While executing the Job , In Job Que I am getting the error as mentioned above, if I am trying to fire the job multiple times.

Please let me know how to close the transaction if one is already running for that.

What task are you executing to importing the data?

I have Created a script , in which , we have created a connection with the target system and then by using SQL query in the script we are fetching the data.

The answer depends on your script code. I do not know what you are doing exactly, but it seems that you are opening a connection and a transaction but do not close it.