Skip to main content

Hello all,

The company I work for has added a service to the CData SQL Gateway application.

This service is linked to a data source that changes during the day. I have found that the service needs to be restarted in order for changes to appear that I need to work on.

Is there a way to automatically restart a service without having to click on this button?

I.e. is it possible to restart a CData SQL Gateway service from the command line? That way I can create a batch script to do this.

Any help would be greatly appreciated.

Thanks,

Adam

Hi @LLadam 

The SQL Gateway service is just like any other service running in your Windows machine. You should see the services running in SQL Gateway being listed under Services:

 

I am not aware of any particular way to restart the service automatically, however you should indeed be able to accomplish what you are looking for from the command line. See the command example below:

net stop "CData SQL Gateway (SAGE)" && net start "CData SQL Gateway (SAGE)"

If you have any other questions feel free to reach out to our support team at [email protected].

Ohk thank you I’ll try this out and see how it goes. 

If I have any other questions I’ll let you know.

 

EDIT:

@Ethem Q this worked! Thank you very much!

Reply


Virtual Event: Data Virtualization, Reimagined Ma”arch 14, 2024 style=
Terms and ConditionsCookie settings