I have been killing myselft to find a way to have the Windows Scheduler
shutdown and startup my database which uses Adaptive Server Anywhere.

Can you help me this? Is there a path or target I can give the scheduler to
do this?

Thank you.

In article <473ca127$1@forums-1-dub>, airmvp23 (AT) gmail (DOT) com says...
If you're running it as a service, execute the standard NET START and
NET STOP commands for starting and stopping the service.


--
Remove the ns_ from if replying by e-mail (but keep posts in the
newsgroups if possible).

In addition to the above comment, if you're starting and stopping the
server via the command-line, the standard dbeng/dbsrv commands will
suffice. "dbstop" can be used to stop the server.

e.g.

Start:

"%SQLANY10%\win32\dbsrv10" -n myserver C:\Database\mydatabase.db -n
mydatabase

Stop:

"%SQLANY10%\win32\dbstop" -c "UID=dba;PWD=sql;ENG=myserver;DBN=mydatabase"

Regards,

ns_dkerber (AT) ns_WarrenRogersAssociates (DOT) com wrote:

--
Jeff Albion, Product Support Analyst
iAnywhere Solutions

iAnywhere Developer Community : http://www.ianywhere.com/developer
iAnywhere Documentation : http://www.ianywhere.com/developer/product_manuals
ASA Patches and EBFs :
http://downloads.sybase.com/swd/summ...&timeframe =0

For services, you can also use dbsvc -u / -x.

-john.
--
John Smirnios
Senior Software Developer
iAnywhere Solutions Engineering

Whitepapers, TechDocs, bug fixes are all available through the iAnywhere
Developer Community at http://www.ianywhere.com/developer

ns_dkerber (AT) ns_WarrenRogersAssociates (DOT) com wrote: