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.

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

Stop the Job Scheduler. From isql, enter:

1> sybmgmtdb..sp_sjobcontrol @name=NULL, @option="stop_js"
2> 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:
```
1> sp_configure "number of locks", 9000
2> go
```
Upgrade the internal Job Scheduler SQL using isql, enter:
```
1> use sybmgmtdb
2> go
1> dbcc upgrade_object
2> go
```
Restart Adaptive Server.
If the sybmgmtdev device is smaller than 100MB, increase the size to at least 100MB. From isql enter the following, where nn.nM is the number of megabytes needed to get to 100 MB:
```
1> use master
2> go
1> disk resize name = 'sybmgmtdev' , size = 'nn.nM'
2> go
```
(Optional) Add more log space. Some 64-bit platforms require additional space for the sybmgmtdb log. From isql, enter:
```
1> use master
2> go
1> alter database sybmgmtdb LOG on sybmgmtdev=20
2> go
```
To upgrade sybmgmtdb using isql, run the installjsdb script that is included and save the output to a file:
```
isql -Usa -Psa_password -Sservername -n -i$SYBASE/$SYBASE_ASE/scripts/installjsdb
-ooutput_file
```
Enable Job Scheduler to start when Adaptive Server starts. From isql,enter:
```
sp_configure "enable job scheduler", 1
```

To start Job Scheduler, from isql, enter:

sybmgmtdb..sp_sjobcontrol @name=NULL, @option="start_js"
go