Toad World® Forums

Database connection and Server control

Hi guys, I’m a new Toad’s user and I have some doubts. I searched in the forum before, but I didn’t find any answer related.

I have two doubts:

  1. Database connection - When I use a database connection, during the execution it’s done a connection using the user I informed. But I don’t see Toad closing the connection and I don’t know if it’s done automatically (when the execution finishes) or if the connection keeps opened for a while, for example. So, I would like to know if the connection will be closed or do I need to force it?

  2. Server control - I have two machines connected at the same network and both of them have TOAD installed. I want to leave some tasks running in the other machine and I want to see them from my machine. Is it possible? If we go on “Job Manager” there is an option to add a new server. I did it (using the other machine’s name) but when I try to connect I got a message saying that the network path is incorrect, but I didn’t find when can I change it, for example.

Do you have any ideas for both (or even one… hehe) questions.

Thanks a lot,
Sue

When you open a connection we leave it open and reuse it when you execute. We also use mutliple connections depending on how you have things set up. IE: A separate conneciton per editor. The application usually uses a minimum of three conenctions. One for loading the database objects in the Object Explorer, one for the data tab of the Database Explorer, and one for an editor. These connections are closed when the application is closed.

On the job manager issue, the job manager monitors SQL Server jobs. Is that what you want to monitor? If this is what you want to do, please post a screen shot of the error and how you configured the server.

If this is not what you want to do, can you detail more about what you want to monitor?

Debbie

Hi Debbie, thanks for your answer.

I understand that each task will have its connection opened, but my doubt is if after finishing the task, the connection is closed? When you say "...These connections are closed when the application is closed..." do you mean Toad or the running task?

About the servers, it's not a server actually, but two simple machines (running windows as SO). One is my machine and the other is the machine where the tasks will run (I don't want the tasks running on my machine), but I need to monitore these tasks, so I would like to add this other machine as a server (in Job manager) and see what is happening on real time.

Please, look at the screen shots. My machine is L3-A17963 and I want do add the machine D3-24659. On screen 2 you can see the message error I get.

Thank you.

Hi Debbie, thanks for your answer.

I understand that each task will have its connection opened, but my doubt is if after finishing the task, the connection is closed? When you say "...These connections are closed when the application is closed..." do you mean Toad or the running task?

About the servers, it's not a server actually, but two simple machines (running windows as SO). One is my machine and the other is the machine where the tasks will run (I don't want the tasks running on my machine), but I need to monitore these tasks, so I would like to add this other machine as a server (in Job manager) and see what is happening on real time.

Please, look at the screen shots. My machine is L3-A17963 and I want do add the machine D3-24659. On screen 2 you can see the message error I get.

Thank you.

RE: Connection. The connection is closed when the application closes.

RE: Monitor tasks. That is a nice idea to be able to monitor automation scripts executing on another server. Unfortunately, we use the windows task manager to schedule and run Automation scripts. This technology does not allow for viewing progress.

If you meant to add server so you could manage a SQL Server job, that would be different and you should be able to do that. Is that you usecase?

Debbie

Hi Debbie,

About the server, it’s not SQL Server what I want, so I think it’s not possible to do what I want :frowning:

About the database connection, when you say application I understand the TOAD itself, but I can keep toad closed and the tasks will continue running. Do you mean application because each task opens a new “application”? So, when the task stops, the application is closed, as the database connection?

Thanks again,
Sue