Upgrading Job Scheduler

After upgrading to the new Adaptive Server, perform the following steps to upgrade Job Scheduler.

You must have $SYBASE/$SYBASE_OCS/bin directory in $PATH so the isql executable is accessible.

Copy the directory services entry for JSAGENT (or jsagent) from the old server to the new server.
Make sure your new server is running.

Stop the Job Scheduler. From isql, issue:

sybmgmtdb..sp_js_wakeup "stop_js", 1
go

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
```
Upgrade the internal Job Scheduler SQL using isql:
```
use sybmgmtdb
go
dbcc upgrade_object
go
```
There is no need to specify any parameters.
Restart Adaptive Server.
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
```
Optionally, add more log space. On some 64-bit platforms more space is need for the sybmgmtdb log. From isql enter:
```
use master
go
alter database sybmgmtdb LOG on sybmgmtdev=20
go
```
Upgrade the sybmgmtdb. Using isql, run the installjsdb script that is included with this release and save the output to a file:
```
isql -Usa -P<sa_password> -S<servername> -n
   -i$SYBASE/$SYBASE_ASE/scripts/installjsdb 
   -o<output_file>
```
Enable Job Scheduler to start when Adaptive Server starts. From isql enter the command:
```
sp_configure "enable job scheduler", 1
```
Start Job Scheduler. From isql enter the command:
```
sybmgmtdb..sp_js_wakeup "start_js", 1
go
```