[CR #371574] If you are upgrading from Adaptive Server versions earlier than 12.5.2, you must run the installjsdb script anytime you upgrade Job Scheduler.
Upgrading Job Scheduler
Disable Job Scheduler before you upgrade Adaptive Sever:
sp_configure "enable job scheduler", 0
Upgrade Adaptive Server. See the installation guide for details on upgrading.
Run the installjsdb script:
isql –Usa –Psa_password –Sservername –i $SYBASE_ASE/scripts/installjsdb
You must have the directory with the location of the isql executable ($SYBASE_OCS/bin)
in your path.
The installjsdb script looks for the sybmgmtdb database. The script updates Job Scheduler tables and stored procedures.
Enable Job Scheduler:
sp_configure "enable job scheduler", 1
To start Job Scheduler, you can either restart the server or enter the following:
use sybmgmtdb� go� sp_js_wakeup "start_js",1 go�
Copyright © 2005. Sybase Inc. All rights reserved. |
![]() |