SQL ANYWHERE SERVICES FROM COMMAND PROMPT

There are cases when customer would like to start up a SQL Anywhere Services at a specific time or after a database backup. The following is a way to start up a SQL Anywhere Services from outside Sybase Central or NT Services (as in Control Panel, Servi

1. Open the 32-bit registry editor (C:\WINNT\system32\regedt32.exe).

On the taskbar, click on “Start” then select “Run”. Type in regedt32 or regedit.

2. Double click on HKEY_LOCAL_MACHINE -> SYSTEM -> CurrentControlSet -> Services

3. For ASA versions 6.x.x/7.x.x/8.x.x, scroll down until you see ASANY. For SQL Anywhere version 5.x.x, scroll down until you see SQLANY. Any services created in SQL Anywhere Service Manager (or from Sybase Central) should be listed here.

4. The name of each individual service would appear as

ASANYx_y or SQLANYx_y

where ‘x’ represents the Service Type:

a – Sample Application

c – Client
e – Standalone Engine
l – Agent for Replication Server

o – Open Server Gateway
r – SQL Remote Message Agent

s – Network Server

and ‘y’ represents the Service Name as seen in the ‘Name’ column in Sybase SQL Anywhere Service Manager.

Find out which key is for the service you want to start from the DOS prompt. Write down the name of the key. Note that the key is

Case sensitive for version 5.x.x but is not case sensitive for version 6.x.x/7.x.x/8.x.x.

5. In DOS, the command to start up any registered NT Services (which include SQL Anywhere/Adaptive Server Anywhere Services) is ‘net start’.

Therefore, the syntax to start up a SQL Anywhere Service from a command prompt (DOS prompt) would be:

net start <key for the service from registry editor>
 

6. Similarly, the NT command to stop any registered NT Services is ‘net stop’  

Therefore, the syntax to stop a SQL Anywhere/Adaptive Server Anywhere Service from a command prompt (DOS prompt) would be:

net stop <key for the service from registry editor>

Credit to: http://www.sybase.com/detail?id=10915