Filter
Top Products
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.
7If 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