Sybase ADAPTIVE 15.0.2 - Manual (Page 94)

Upgrading Job Scheduler
78 Adaptive Server Enterprise
Upgrading Job Scheduler
After upgrading to the new Adaptive Server, perform the following steps to
upgrade Job Scheduler.
Note You must have $SYBASE/$SYBASE_OCS/bin directory in $PATH so the
isql executable is accessible.
v Upgrading Job Scheduler
1 Copy the directory services entry for JSAGENT (or jsagent) from the old
server to the new server.
2 Make sure your new server is running.
3 Stop the Job Scheduler. From isql , issue:
sybmgmtdb..sp_js_wakeup "stop_js", 1
go
4 Ensure that at least 9000 locks are configured. If the number of locks on
the server is less than 9000, use
sp_configure to increase the number of
locks:
sp_configure "number of locks", 9000
5 Upgrade the internal Job Scheduler SQL using isql :
use sybmgmtdb
go
dbcc upgrade_object
go
There is no need to specify any parameters.
6 Restart Adaptive Server.
7 If the sybmgmtdev device is less than 100MB, change the device to be a
minimum of 100MB. From isql enter the following, where nn.nM is the
number of megabytes needed to get to 100 MB:
use master
go
disk resize name = 'sybmgmtdev' , size = 'nn.nM'
go
8 Optionally, add more log space. On some 64-bit platforms more space is
need for the
sybmgmtdb log. From isql enter:
use master